Listing Page

A friend asked: “I know we can use Oracle Enterprise Manager without the packs. However, is there any document that shows in detail what database monitoring and alerting functionality is provided by E...

This blog post is about some questions and answers plus feedback about suggestions. This is to do with a technical article that I had written and which was published on the Oracle Technical Network (...

Before Oracle 12c, pluggable databases didn’t exist; whenever we wanted to clone a database we had use either RMAN Backup and Restoreor RMAN Duplicate (Active or from backup location). There are sever...

Hi, There is quite the scenario that the Oracle Cost-Based Optimizer (CBO) uses when deciding when to use indexes to process your SQL. I go into this in great detail in my SQL Performance Tuning cours...

In This Post i will show how to create backup for Dbaas Open the Oracle Database Cloud Service console. Click the database deployment for which you want to create a backup. Click the Administration ...

Hi, I have used this option to show SQL bind variable content for a while, I want to show you how I avoid running SQL Trace with this Toad Explain Plan feature. Toad has also made it very easy to run ...

With the loss of the Oracle Standard Edition One license, and the free Oracle Express Edition database stuck at the old 11g Release 2 from 2014, many smaller projects are considering whether MySQL mig...

Yet another exciting journey with Oracle bugs and challenges. Here is the story for you. One of our recent successful migrations was a single instance Oracle EBS 12cR1 database to Oracle Super Cluster...