Question: What are the
final_blocking_instance, and final_blocking_session columns
of gv$session used for?Answer: There
are two new column in 11g r2 gv$session view to
help in identifying blocking sessions,
final_blocking_instance, and final_blocking_session:
- final_blocking_instance: This
column of gv$session is the instance identifier of the
final blocking session. This column is valid only if
final_blocking_session_status=valid.
- final_blocking_session: This
column of gv$session is the session identifier
of the final blocking session. This column is valid only
if final_blocking_session_status=valid.
This example script extracts final_blocking_instance
and final_blocking_session from gv$session.
For full scripts, see the
Oracle Script
collection download.
select
inst_id||' '||sid||','||serial# inst_sid_s#,
username,
row_wait_obj#||','||row_wait_block#||','||row_wait_row#
obj_lck,
blocking_session_Status||'
'||blocking_instance||','||blocking_session blk_info,
final_blocking_session_Status||'
'||final_blocking_instance||','||final_blocking_session
f_blk_info,
event,
seconds_in_wait
from
gv$session
where
lockwait is not null
order by
inst_id;