Blog Feed

Collaborate 2019 Presentations

Collaborate 2019 will take place April 7-11 in San Antonio this year.This time I have 3 presentations accepted and ready to roll starting April 7th.Simplifying EBS 12.2 ADOPIn this session I’ll talk about basic ADOP concepts, how to us them and real-life problems and best practice recommendations.Listen to your Database. How to Understand an Oracle… Continue reading Collaborate 2019 Presentations

Configure Oracle Cloud Infrastructure’s VCN Network

Oracle Cloud Infrastructure requires a VCN (Virtual Cloud Network) to be created in order to connect to DB Systems (Bare Metal and VM). There are basically tow options to configure this VCN. ·       Public Subnet with Internet Gateway·       Private Subnet The Public Subnet with Internet Gateway will expose the network to the Internet. The Internet… Continue reading Configure Oracle Cloud Infrastructure’s VCN Network

Avoid Transaction Errors Due To Tablespace Shortage

How many times we have had a call from application teams regarding a session error due to a tablespace (either DATA, TEMP or UNDO) getting 100% full?How many times we had ask for an estimate of space used by a process, session or transaction?There are several options that can help us overcome this type of… Continue reading Avoid Transaction Errors Due To Tablespace Shortage

Oracle Cloud Infrastructure – Database Service – Bare Metal

The Database service part of the Oracle Cloud Infrastructure offers the autonomous and user-managed database options. The user-managed can be customized and you can choose between using Bare Metal, Virtual Machine or Exadata systems. These are called DB Systems. The autonomous database cannot be customized as they come pre-configured. You can choose between Autonomous Transaction… Continue reading Oracle Cloud Infrastructure – Database Service – Bare Metal

Oracle 19c Available for Exadata On-Premises

Oracle just released Oracle 19c for Exadata On-Premises. This is just close to a year when they released the 18c version for Exadata On-Premises on February 16th 2018.If they follow the same schedule, we may expect 19c for the Database Cloud Service early next month.Release dates can be found in the MOS Doc Id 742060.1I… Continue reading Oracle 19c Available for Exadata On-Premises

OEM 12c/13c Metric Extension – Collection Result Maximum Flood Control

I recently had an issue in OEM 12c while creating a Metric Extension that was returning more than 5000 records. In OEM 12c versions 12.1.0.4 and 12.1.0.5 there a flood control mechanism in order to limit the maximum number of rows for a metric. You can also verify this in the agent_inst/sysman/log/gcagent.log file:2018-10-08 13:38:50,330 [66:F119EDFE:GC.Executor.1… Continue reading OEM 12c/13c Metric Extension – Collection Result Maximum Flood Control

Install VirtualBox on MacOS using HomeBrew

I’m fairly new on using MacOS. I’ve been struggling finding shortcuts and keys that I was very comfortable with in Windows. I friend of mine helped me with tips and also mentioned to install HomeBrew in order to install VirtualBox. Here’s a short post on how to do it.First you need to install Xcode. Xcode… Continue reading Install VirtualBox on MacOS using HomeBrew