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...
This article explains how to configure Data Guard between RAC primary and standby alone (Oracle restart) Standby database with easy and all advanced methods to achieve Oracle maximum availability arch...
Overview In typical data warehousing environment existence of huge partitioned tables is very common, gathering statistics on such tables is challenging tasks. For partitioned tables there are two typ...
Oracle 12c has introduced the multi-tenant architecture for Oracle database, where a single container database (CDB$ROOT) can have multiple pluggable databases (PDBs). This new architecture is introdu...
This trace has been around for quite a while. I’m not sure when it first showed up but easily back to Oracle8i. This is the Cost-based Optimizer trace. This trace really tells you ‘why did the CBO pr...
Fragmentation in a tablespace is thought to be a performance killer. This has been proven to be a myth. Fragmentation by itself does not cause performance problems in a multi-user Oracle database. Wha...
The DBMS_JOB package is actually an API into an Oracle subsystem known as the job queue. The Oracle job queue allows for the scheduling and execution of PL/SQL routines (jobs) at predefined times and/...
A frequent question that I have received from many DBAs is: my undo tablespace is almost full, how can I be sure that the space will be reused? Well, First you have to know that there are two kind of...
In this article I will show you how undo retention time is set when we have an Undo tablespace with autoextend enabled and also disabled. I will give you rules in order to remember this easily: Rule-...
This article is focused on Monitoring and Troubleshooting of Data Guard configuration using the GUI method i.e. Enterprise manager 12c(cloud control), Here we will go through with Data Guard Administr...
This article is focused on how to monitor and troubleshoot the Data Guard when managing with Broker. There are many ways to monitor Data Guard such as using Generic/Traditional views, Using Grid contr...
