ORACLE

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 that are used by the …

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

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-600adde849acb923225404/] Standby databases also receive connection …

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 you are searching pl sql …

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 2015 RFS[18]: Assigned to RFS …

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 (16198) LGWR: Destination LOG_ARCHIVE_DEST_2 network …

This article contains information about dropping database in Oracle 19c and unistalling Oracle 19C binaries in Windows. STEP1 : Connect As SYSDBA [crayon-600adde84a3c9779187733/] STEP 2: Shut Down The Database [crayon-600adde84a3cf381335060/] …

You can find the below informations about Snapshot Standby Database in this article. What is Oracle Snapshot Standby Database? Convert Physical Standby to Snapshot Standby Convert Physical Standby to Snapshot …

What is Read Only Tables in Oracle? It is possible to use read only tables in Oracle databases starting from 11.1. You can not update read only tables. A table …

When trying to send an e-mail with the UTL_MAIL package, the error “ORA-06502: PL / SQL: numeric or value error” is received when the smtp_out_server start parameter is not set …