when doing a database lock check of oracle database, we need check following sys tables.
v$active_session_history as a
v$sql as s
join by sql_id
a.user_id <> 0 will exclude SYS user.
a.sample_time to check the data and time.
a.blocking_session is not null
No comments:
Post a Comment