ORACLE

Below are some of the basic hygiene techniques and concepts we should keep in mind to get the maximum performance out of our query . …

Logical Standby Database does not support replication of all data types, tables, commands and PL / SQL Packages. Therefore, before converting a Physical Standby database …

What is a logical standby database? Apart from Physical and Snapshot Standby Database, it is another type of Standby Database. It is an active database …

After the STANDBY Database is installed and the necessary configurations were made, when INSTANCEs wanted to be START, one of the INSTANCEs opened and the …

The index scans are the table access paths used by the oracle optimizer to generate the best execution plan. There are different types of scans …

We will explain Oracle PDB Automatic Startup in 12c in this article. STEP 1 :-  Check The List Of PDBS . Here In My case …

When querying the status of the configuration from broker, errors like below were seen. Warning: ORA-16664: unable to receive the result from a database [crayon-676cfef206b7a356685257/] …

This article is an index of PL/SQL Tutorial. You can find almost everything for beginners in this article and in related articles about PL/SQL. If …

The following errors were seen in the ALERTLOG file of the STANDBY Database if the PRODUCTION Database suddenly shuts down. (STANDBYDB) Mon Dec 21 17:53:29 …

Redo Transport to the standby has stopped after the ORA-16198 error. ERROR ORA-16198: LGWR received timedout error from KSR LGWR: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect …