Re: HELP: Oracle Data Dictionary

--In article <301cjk$9ao_at_synapse.bms.com>, baranoski_at_sis.bms.com () writes:

|>>>Hello,
|>>>
|>>>I'm trying to create a view that shows which user has which table locked, and
|>>>the type of lock.
|>>>
|>>>So far, I can find which type of lock the user has but I haven't been able to
|>>>figure out how to tell which user has which table locked.
|>>>
|>>>Does anyone have nay ideas?
|>>>Any help would be greatly appreciated!
|>>>
|>>>
|>>>Thanks,
|>>>
|>>>Lori
|>>>baranoski_at_sis.bms.com
|>>>

Have you tried the ORACLE-supplied script "UTLLOCKT.SQL" (the directory where this script file is found is System dependent). You will need to run the script "CATBLOCK.SQL" ** BEFORE ** running the above script, to create the necessary views.

Hope this helps,

Yakir.

Yakir Lavie
(email: lavie.yakir_at_iso.mts.dec.com)
DIGITAL - Israel