ORACLE

If the Oracle database is in archive log mode, the redo logs are copied as archive files. Archive files will be transferred to the directory …

What is Diagsnap in Oracle 12c Diagsnap is a new feature introduced in 12.1.0.2 GI, which manages the diagsnap resource, which collects additional operating system …

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

If you have created and enabled a new service and then created a pluggable database, you may receive this error if you want to switch …

We can reset the ILOM SP of compute nodes and cell nodes as follows: You can connect to the Ilom IP via ssh and run …

Connect to Root Container The connection to the root container is the same as connecting to the database instance in previous versions. Connection can be …

Disk scrubbing exists on Exadata cell nodes to automatically repair the failed sector of the disk when the system is idle without compromising system performance. …

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

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

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