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...
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...
Concerned about risks and want to lock down your Oracle client for end user Windows PCs? Have a need for the ‘cross connection query’ feature of Toad Data Point? The solution is within your grasp! Let...
We performed an EBS R12.2 RAC to RAC clone and after successful completion of cloning we were not able to connect database using sqlplus command and it was giving the below error: [oracle@racnode1 12...
The notifications emails of a “planned” downtime is one of the annoying things of monitoring systems. You forget creating blackout and you start a maintenance work, and you get lots of notifications m...
The following case just want to share it in case anyone need it, development wants to import the existing table in the siebel schema into the new name to check the data integrity: Oracle Provide you w...
This article is focused on how to do troubleshoot the Logical standby database and monitoring the logical standby database apply, In detail we will go through how the SQL Apply process actually works ...
In this article we will learn How to create a new Physical Standby using Backup Set and also DUPLICATE in RMAN, this is a fast way to create Physical Standby when to create the Standby using ACTIVE DA...
In this article we will see an interesting thing. When I was starting reading Oracle 12c Documentation I read that one of the enhancements of RMAN was Multi Section and another enhancement was the int...
Oracle Text (formerly known as InterMedia Text and ConText) is a full text indexing functionality. With Oracle text indexes (also known as Domain index), we can index text documents and search it base...
Since in Oracle Database 12c we can now use Active Duplicate using Backup set we also have another option, create that backupset Compressed, in that case what we are doing is to compress the BackupSet...
