Re: Enqueue Diagnosis

From: F. antasy <namreh36_at_yahoo.com>
Date: Wed, 13 Aug 2003 20:31:45 +0200
Message-ID: <bhe06h$r84$1@news2.tilbu1.nb.home.nl>

"Matt" <mccmx_at_hotmail.com> schreef in bericht news:cfee5bcf.0308130317.75036b6c_at_posting.google.com...
> I have an 8.1.7 database which is starting to bottleneck on Enqueue
> waits.
>

....
Any ideas on this one....??
>
> Matt

What not use v$lock? It shows the blocking and the blocked session(s). With a TX lock mode 6, there is no data object to be retrieved. Usually fast enough.

Kind Regards,

Herman de Boer
IT Consultancy Group bv Received on Wed Aug 13 2003 - 13:31:45 CDT