Re: Locks

From: Steve Adams <steve.adams_at_ixora.com.au>
Date: Thu, 03 Feb 2000 17:53:23 GMT
Message-ID: <3899c019.253946465@news.eagles.bbs.net.au>

Hi Greg,

Yes, it is perfectly normal. DBWR holds an MR lock on each datafile all the time.

Regards,
Steve Adams

http://www.ixora.com.au/

http://www.oreilly.com/catalog/orinternals/

http://www.christianity.net.au/

On Thu, 03 Feb 2000 16:05:11 GMT, Greg Stark <greg-spare-1_at_mit.edu> wrote:

>
>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 - 11:53:23 CST