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 -> Re: Internal Lock Waits

Re: Internal Lock Waits

From: Vinh <hvcao_vn_at_yahoo.com>
Date: 17 Apr 2002 19:02:46 -0700
Message-ID: <d387a07.0204171802.2a8b8b46@posting.google.com>


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

Original text of this message

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