Revision [1019]
Last edited on 2007-10-10 00:08:13 by WikiAdminAdditions:
===ID-ing deadlocks===
cd $ORACLE_HOME/rdbms/admin
connect as sys
@CATBLOCK.SQL;
@UTLLOCKT.SQL;
cd $ORACLE_HOME/rdbms/admin
connect as sys
@CATBLOCK.SQL;
@UTLLOCKT.SQL;
Revision [611]
Edited on 2007-05-29 20:15:03 by WikiAdminAdditions:
===List active SQL===
select s.sid,
s.serial#,
s.username,
optimizer_mode,
hash_value,
address,
sql_text
from v$sqlarea sqlarea, v$session s
where s.sql_hash_value = sqlarea.hash_value
and s.sql_address = sqlarea.address
and s.username is not null;
select s.sid,
s.serial#,
s.username,
optimizer_mode,
hash_value,
address,
sql_text
from v$sqlarea sqlarea, v$session s
where s.sql_hash_value = sqlarea.hash_value
and s.sql_address = sqlarea.address
and s.username is not null;
Deletions:
Revision [203]
Edited on 2007-04-16 07:27:27 by WikiAdminAdditions:
%%(sql;freespace.sql)
Revision [202]
Edited on 2007-04-16 07:27:05 by WikiAdminAdditions:
%%(sql)
%%(sql)
%%(sql)
Revision [138]
Edited on 2007-04-14 21:31:22 by WikiAdminAdditions:
{{parent page="Oracle"}}
