Re: Table-locks

In article <399bd482.22914399_at_news.tele.dk>,   bma_at_NOSPAM.geocities.com (The BMA man) wrote:
> On Mon, 14 Aug 2000 06:29:21 -0700, Mark D Powell
> <mark.powellNOmaSPAM_at_eds.com.invalid> wrote:
>
> >All Oracle provided database $ORACLE_HOME/rdbms/admin/cat*
> >scripts should only be ran as sys or internal. If you ran
> >catblock as system, delete the objects and rerun as sys.
>
> I have rerun the catblock script as sys, and it have created some
> tables. Thats ok.
>
> >
> >You should be able to run utllockt.sql as any id with create
> >table privilege and select any table privilege.
>
> But there seems to be missing some tables because the utllockt scripts
> cannot create the tables it needs, and I do not get any graphs.
> What can I be doing wrong?
>
> Regard
>
> Brian Madsen
>

Were there any errors when sys ran catblock.sql. Back in ver 7 days there was a syntax error on one of the creates that caused the script to error off though I was pretty sure it was fixed at 8+. It had to do with a misplaced comment near the bottom of the statement.

You will only get a graph when there are lockwaited sessions so you will need to wait until you see several sessions with a non-null lockwait column value.

After checking both of the above, what objects are missing? You should be able to find the code in the appropriate rdbms/admin script and via cut and paste rerun it in as sys.

--
Mark D. Powell  -- The only advice that counts is the advice that
 you follow so follow your own advice --


Sent via Deja.com http://www.deja.com/
Before you buy.