ORACLE

Automatically Run Configuration Scripts Before 19c in the oracle database software installation requires manual effort to run the root.sh scripts. But from 19c we can …

There are various methods and different tools for creating a pluggable database within a container database (CDB). The methods and tools to create a pluggable …

Introducing Oracle Net Services Oracle Net services are often used to enable network connections for applications or different clients to connect to databases. Allows connection …

Before 12c if one of the standby database goes out of sync with respect to the primary database we have to perform the below steps …

What is a Multitenant Database? As of version 12.1, you can design your databases as a multitenant database (CDB). It consists of a container database, …

When the Exadata database is upgraded to version 12.2, “gc cr request” and “gc buffer busy acquire” wait events occur in many operations in the …

During the index rebuild process, if some of the blocks belonging to the index are on a corrupted datafile, you receive the error “ORA-08102: index …

Due to an unknown situation in Oracle 11g databases, “ORA-00600: internal error code, arguments: [qcsprfro_tree: jrs present]” error is received during refresh of some materialized …

With the DBMS_REDEFINITION package in the Oracle database, it is possible to modify the structure of the tables online. We can convert a non-partitioned table …

Being a DBA we must know the difference between the SQL profile and the baselines. To start with we know that optimizer uses the information …