Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Any one has good script to find out "Who lock what" from 9i

Re: Any one has good script to find out "Who lock what" from 9i

From: Chuck <chuckh_at_softhome.net>
Date: Fri, 28 Jun 2002 16:00:41 -0400
Message-ID: <afif9a$eklbg$1@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 - 15:00:41 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US