Category: ORACLE

Diagsnap in Oracle 12c

What is Diagsnap in Oracle 12c Diagsnap is a new feature introduced in 12.1.0.2 GI, which manages the diagsnap resource,

You can list applied patches in Oracle by query except for “opatch”. You can use DBA_REGISTRY_HISTORY for databases 11g and

If you have created and enabled a new service and then created a pluggable database, you may receive this error

We can reset the ILOM SP of compute nodes and cell nodes as follows: You can connect to the Ilom

Connect to Root Container The connection to the root container is the same as connecting to the database instance in

Disk scrubbing exists on Exadata cell nodes to automatically repair the failed sector of the disk when the system is

To perform various operations on database objects, system and object privileges must be assigned to users. Each system privilege allows

You can find the undo usage of a session with the following query. Historical information is also available. You can

You may need to enable trace for a session for many reasons. For example, you may need to determine which

The PDB$SEED or SEED database is a pluggable database template for pluggable databases to be created by users. Used as