|
Click here to
return to Oracle DBA code depot.
Note that this script is un-supported
with no warranty of any kind. The user of this scripts accepts full
responsibility for all results from these scripts and effects on their database.
--******************************************
--
-- alllocks.sql
--
-- This script shows all locks
in the database.
--
-- Copyright © 2001 by Donald
K. Burleson
--
--******************************************
--**********************************************
-- We must run this script as
the SYS user
--**********************************************
accept syspass char prompt
"Enter password for SYS user: ";
connect sys/&&syspass
prompt Note that $ORACLE_HOME/rdbms/admin/catblock.sql
prompt must be run before this
script functions . . .
@$ORACLE_HOME/rdbms/admin/catblock.sql
set linesize 132
set pagesize 60
spool /tmp/alllocks
column owner format
a10;
column name format
a15;
column mode_held format
a10;
column mode_requested format
a10;
column type format
a15;
column lock_id1 format
a10;
column lock_id2 format
a10;
prompt Note that $ORACLE_HOME/rdbms/admin/catblock.sql
prompt must be run before this
script functions . . .
prompt Querying dba_waiters . .
.
select
waiting_session,
holding_session,
lock_type,
mode_held,
mode_requested,
lock_id1,
lock_id2
from
sys.dba_waiters;
prompt Querying dba_blockers .
. .
select
holding_session
from
sys.dba_blockers;
prompt Querying dba_dml_locks .
. .
select
session_id,
owner,
name,
mode_held,
mode_requested
from
sys.dba_dml_locks;
prompt Querying dba_ddl_locks .
. .
select
session_id,
owner,
name,
type,
mode_held,
mode_reque
from
sys.dba_ddl_locks;
prompt Querying dba_locks . . .
select
session_id,
lock_type,
mode_held,
mode_requested,
lock_id1,
lock_id2
from
sys.dba_locks;
|
