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 10:14:17 -0400
Message-ID: <afhqvq$ecuv2$1@ID-85580.news.dfncis.de>

What's wrong with using the dba_waiters and dba_blockers views? Don't they exist in 9i?

"Evan Cao" <eecao_at_yahoo.com> wrote in message news:a618084.0206280604.65f37b0a_at_posting.google.com...
> I had scripts from metalink note 148517.1 to find out "who lock what". It
works
> fine prior to 9i. It took too long under 9i.
> Thanks.
Received on Fri Jun 28 2002 - 09:14:17 CDT

This message: [ Message body ]
Next message: Joe Salmeri: "Re: Oracle 8i (8.1.7.0.1) + Redhat Linux 7.2 = Cannot create tablespace file > 2 gb"
Previous message: Evan Cao: "Any one has good script to find out "Who lock what" from 9i"
In reply to: Evan Cao: "Any one has good script to find out "Who lock what" from 9i"
Next in thread: Anton Buijs: "Re: Any one has good script to find out "Who lock what" from 9i"
Reply: Anton Buijs: "Re: Any one has good script to find out "Who lock what" from 9i"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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