There is a NO WAIT clause you can add. I think it goes right after the FOR
UPDATE clause, but cant remember. Info should be on technet.
"Ram" <rapparaju_at_yahoo.com> wrote in message
news:c14701f.0203041729.1a506cb9_at_posting.google.com...
> 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 - 18:37:45 CST
