Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Locks
Is this normal? What are all these "Media Recovery" locks?
SQL> select count(*),lock_type from dba_locks group by lock_type;
COUNT(*) LOCK_TYPE
---------- -------------------------- 2 DML 45 Media Recovery 1 Redo Thread 1 Temp Segment 2 Transaction
--
greg
Received on Thu Feb 03 2000 - 10:05:11 CST