"Glen A Stromquist" <glen_stromquist_at_no.spam.yahoo.com> wrote in message
news:ujBla.98495$B54.2725348_at_news1.telusplanet.net...
> One of our new apps is freezing due to a large number of blocking locks
> accumulating, I have been able to view the locks from DBartisan and
> usually getting the offending user to log off clears the problem up.
>
> However I want to probe a little more via sql and after some research
> found that I should be able to get more info from running the
> utllockt.sql, which needs the catblock.sql script run to create the
> neccesary views. I ran the catblock.sql (as sysdba) and recieved errors,
> mostly grant select on <new_view> to select_catalog_role. Then after I
> ran the utllockt.sql I could no longer see the dba_lock view and doing a
> desc on dba_blockers causes sqlplus to error out and crash.
>
> Is there something I missed here? Should I just run the scripts again?
It does seem odd, I would definitely run the script again (spooling out to
file to catch any errors). I'd also check that you are running the 817
scripts against this database, I have in the past run
@?/rdbms/admin/<script> only to realize that 9i scripts from my client home
don't really work against an 8i database. <fortunately this was statspack
creation>.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
Received on Mon Apr 14 2003 - 03:05:04 CDT
