How To Setup Passwordless ssh in Exadata Using dcli
Although passwordless ssh connection is established between compute node and cell nodes in the Exadata installation, this connection can be
Category: ORACLE
How To Find Wasted Space in Table in Oracle
Gaps occur in the blocks due to deletion operations in the tables. These spaces remain as wasted space. These spaces
enq: TM – contention
Oracle attempts to put a lock on the table with the foreign key if a change is made to the
enq: HW – contention
Enqueues are shared memory structures that serialize access to database resources.(locks) They can be associated with a session or transaction.
How To View Active Requests on Exadata Cell Node
An active request represents a client- or application-centric view of I / O requests processed by the cell node. You
ORA-14086: a partitioned index may not be rebuilt as a whole
If you attempt to rebuild an entire index while rebuilding a partitioned index, you may receive an ORA-14086 error.
|
1 2 3 4 5 |
SQL> alter index index01 rebuild; alter index index01 rebuild ERROR at line 1: ORA-14086: a partitioned index may not be rebuilt as a whole |
Drop Temp Tablespace Taking Long Time
If there is a session that uses the temp tablespace you are trying to drop, the drop operation starts waiting.
enq: SS – contention wait event
“enq: SS – contention” wait event may occur in problems with temp tablespace usage in Oracle RAC databases. At the
How To Connect To Oracle Cloud Database using SSH
We can connect to database servers in Oracle Cloud environment or other linux servers using ssh private key. After creating
How To Create SSH Key Pair for Oracle Cloud
We connect to all servers that we create in Oracle Cloud environment with ssh public and private key. When creating