|| s2.username || || s2.machine || ' ( SID=' || s2.sid || ' ) ' AS blocking_statusįrom gv$lock l1, gv$session s1, gv$lock l2, gv$session s2 || ' ( THIS SID=' || s1.sid || ' ) is blocking ' You can find momentarily blocking session and lock with below scripts. ![]() Order by 1 desc) sub where sub.sql_id=v.sql_id Owner||'.'||object_name||':'||nvl(subobject_name,'-') obj_name,s.program,s.module,s.machineįrom dba_hist_active_sess_history s, dba_objects o (select sample_time,s.sql_id sql_id, session_state, blocking_session, select v.sql_text,v.sql_fulltext,sub.* from v$sql v, Change date time column which is specified with bold character. You can find historical blocking session and lock with below scripts. I will share Find Oracle blocking sessions and Kill Locked Session Scripts & Locked Objects scripts and other Oracle DBA Scripts ( Oracle RAC, Dataguard, Performance Tuning, Monitoring and etc.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |