We have seen managing Global data services in Data Guard configuring by failover test and so on, if any situation occur like the role transitions of the Data Guard configuration between Primary databa...
For most people troubleshooting SQL query performance problems is a necessity rather than a preference. Very often they are using a trial and error strategy to overcome those frustrating situations. U...
This article explains how to create service, managing services and close view of service failover to the preferred databases and various other options related to services, The GDS introduction and the...
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...
Introduction We've already seen the introduction, architecture of GDS in a previous article; this article explains how to install Global service managers and deploying GDS to the Data Guard and go thr...
Prior to Oracle 12c we are familiar with the local data services which offers the connectivity to the desired database and managed workload across instances and route the connection to the standby dat...
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...
Introduction Execution of a SQL statement in an Oracle Parallel Server environment is slightly different then in a single instance environment. In an OPS environment additional instructions are execut...
Naming Conventions A naming convention is used when Oracle creates managed database datafiles. The following table shows the naming conventions fo the database datafiles. (Note that these may differ f...
A tablespace is the primary level of logical storage in an Oracle database. All "hard" database objects such as tables, indexes, sequences, and clusters reside in tablespaces. An Oracle database can ...
