Wednesday, August 18, 2010

Check if there is a block wait or request

In Oracle check if there is a block wait or request

select * from V$LOCK where REQUEST > 1 or block > 0;

No comments: