Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Internal Lock Waits
Hi,
If you use Precise, pls go to Performance Warehouse to look at latch
contention to find what latch wait!
From recent activity you can find exactly what SQL statement cause by
internal lock wait. Pls let me know what latch wait and what SQL
statement have high internal lock wait!
Regards
Vinh
dbaguru_at_yahoogroups.com
dhoffman0917_at_yahoo.com (Donna) wrote in message news:<79808a91.0204160712.2e70c976_at_posting.google.com>...
> This "Internal Lock Wait" was displayed while viewing stats from a database
> performance monitoring tool called "Pulse" by Precise Software.
>
> It is also mentioned briefly in Oracle8i Internals book by Steve Adams.
Received on Wed Apr 17 2002 - 21:02:46 CDT