ORACLE

Undo tablespace is extremely used during peak times. There is a possibility that some operations may be interrupted if you go uncontrolled. You should regularly …

Why DBA should pass the Oracle Database 19c OCP exam? DBA should get ready for new features & they should test themselves through latest certification. …

Although passwordless ssh connection is established between compute node and cell nodes in the Exadata installation, this connection can be broken due to some problems. …

Gaps occur in the blocks due to deletion operations in the tables. These spaces remain as wasted space. These spaces should be determined and shrink …

Oracle attempts  to put a lock on the table with the foreign key if a change is made to the main table with the primary …

Enqueues are shared memory structures that serialize access to database resources.(locks) They can be associated with a session or transaction. HW (high water mark) is …

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