Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Any one has good script to find out "Who lock what" from 9i
"Anton Buijs" <aammbuijs_at_xs4all.nl> wrote in message
news:afied4$j4b$1_at_news1.xs4all.nl...
> Views dba_waiters and dba_blockers are slow in my experience.
Do you have stats on your sys schema? That can slow it down. In some cases, where they appear to run slow I just put a rule hint on it and then they run just fine. They usually come back in less than a second. Received on Fri Jun 28 2002 - 15:00:41 CDT