Re: How to find the Time spent in Waiting (like FOR UPDATE)

Take a look at v$session_event. I think you're looking for time_waited on 'enqueue' events.

Richard

Ram wrote:
>
> Hi,
>
> Our application does lots of Selects with FOR UPDATE. As number of
> users running such transactions increases, the overall response time
> is growing. Is there a way to findout how much of the database time
> is actually spent in waiting.
>
> Thanx,
> -Ram
Received on Mon Mar 04 2002 - 20:18:01 CST