Blog Feed

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

OEM 13c – AMP EBS Discovery Error Due To Lack Of Privileges

We recently had to enable monitoring for an EBS 11i system using the Application Management Pack. Even though the EM_MONITOR user was already provisioned by the EBS patch, the discovery was failing due to lack of privileges on several FND tables.My Oracle Support shows several bugs related to missing privileges like the one below, but… Continue reading OEM 13c – AMP EBS Discovery Error Due To Lack Of Privileges

Execution Plans, Hints and Outlines in Oracle 18c

Today's post is about execution plans. This quick example using the HR sample schema, highlights the importance of using SQL Hints to influence the execution path.Let me use below SQL as an example:SELECT     COUNT(*)FROM    hr.employees a,    hr.departments b,    hr.locations cWHERE    a.department_id = b.department_id    AND b.location_id = c.location_id    AND a.salary > 3000    AND c.postal_code IS… Continue reading Execution Plans, Hints and Outlines in Oracle 18c