1. Check locked object:
selectc.owner, c.object_name,c.object_type, b.sid, b.serial#, b.status, b.osuser, b.machine
from v$locked_object a ,
v$session b,
dba_objects c
where b.sid = a.session_id
and a.object_id = c.object_id;
2. Then use Sid from above queries to see what its doing.
select s.sid, s.username, s.schemaname, s.osuser, s.machine, s.terminal, s.program, sa.sql_text from v$sqlarea sa, v$session s
where s.sql_hash_value = sa.hash_value
and s.sql_address = sa.address
and s.sid=&sid
select sid,username,status,blocking_session,wait_class,seconds_in_wait,state
from v$sessionwhere sid=&sid
This blog is useful for Database, Business Intelligence, Bigdata and Data Science professionals.
Subscribe to:
Post Comments (Atom)
Stop Memorizing SQL Part 3 : A Practical SQL Cheat Sheet for Beginners
A Practical SQL Cheat Sheet for Beginners When learning SQL, students often struggle to remember the correct syntax during exams or practic...
-
1. To change the scheduled time of oracle job and force it to run at certain time, use the set_scheduler_attribute procedure.e.g. To start j...
-
Move distribution database to another drive: There are scenarios in SQL server Replication that we need to move datafiles and logfiles of di...
-
* Stored procedures generally result in improved performance because the database can optimize the data access plan used by the procedure an...
No comments:
Post a Comment