Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Locks

Locks

From: Greg Stark <greg-spare-1_at_mit.edu>
Date: Thu, 03 Feb 2000 16:05:11 GMT
Message-ID: <87zoti8e6q.fsf@HSE-Montreal-ppp33976.qc.sympatico.ca>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US