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 …

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-6742cca5686ca389921704/] …

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 …

This article contains information about dropping database in Oracle 19c and unistalling Oracle 19C binaries in Windows. STEP1 : Connect As SYSDBA [crayon-6742cca568eff163443585/] STEP 2: …

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 …

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 …

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 …