ORACLE

An active request represents a client- or application-centric view of I / O requests processed by the cell node. You can view active requests on …

If you attempt to rebuild an entire index while rebuilding a partitioned index, you may receive an ORA-14086 error. [crayon-676da66babe76665724009/] To solve the problem, rebuild …

If there is a session that uses the temp tablespace you are trying to drop, the drop operation starts waiting. The drop operation is completed …

“enq: SS – contention” wait event may occur in problems with temp tablespace usage in Oracle RAC databases. At the same time, SMON may be …

We can connect to database servers in Oracle Cloud environment or other linux servers using ssh private key. After creating a server or database deployment, …

We connect to all servers that we create in Oracle Cloud environment with ssh public and private key. When creating our database server or normal …

Creating a new instance using Oracle Database Cloud Service on Oracle Cloud is called database deployment. It is possible to simply create a database and …

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 …