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 (...
Introduction In a traditional environment development and testing are separated into two phases: developers who build features and quality assurance engineers responsible for testing them. Quality eng...
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...
Oracle Database 12c offers several enhancements to improve security in your PL/SQL program units. These features include: Code-based access control: fine-tune access to database objects inside prog...
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...
Here are the presentations I gave at OUG Norway last week. These are also available on SlideShare Predictive analytics: Mining gold and creating valuable productfrom Brendan Tierney...
“The only thing you can do easily is be wrong, and that's hardly worth the effort.”― Norton Juster, The Phantom Tollbooth Oracle provides two parameters that affect the PGA that look very similar but...
