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
Ofcourse not! Oracle always say not to analyze the sys schema!
And is this possible: statistics on V$-views? In most cases they show data
from memory structures!
Chuck <chuckh_at_softhome.net> schreef in berichtnieuws
afif9a$eklbg$1_at_ID-85580.news.dfncis.de...
|
| "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 - 16:10:56 CDT