Basics of Locks and Blocking Session in Oracle 19c

Basics of Locks and Blocking Session in Oracle 19c

-- Blocking Session in the Database --
SET lines 300
col wait_class for A20
col event for A35
SELECT blocking_session, sid, serial#, wait_class, event, seconds_in_wait
FROM v$session
WHERE blocking_session is not NULL
ORDER by blocking_session;

-- Get the types of locks by the Blocking Session
SET LINES 300
COL username FOR A30
FROM v$lock l, v$session s

-- Object Detail
set lines 300
col owner for A16
col object_name for A20
select owner, object_type, object_name, object_id from dba_objects where object_id=&object_id; -- ID1 from Previous Query

[farheenmaheen]

for theory there are many videos, but realtime issues resolving is the key, please continue like this

[oracledbacafe]

Thanks all for 1k+ views. My first video with 1k+ views.😀

[farheenmaheen]

Saw many oracle related videos, the way your videos are, excellent. keep it up the good work.

[gudipudiseema]

Thanks for re-uploading this sir. Please try to update with new videos on day to day activities and issues we face in real time and how to solve those issues.. mostly weekly activities, monthly activities
your content is really helpful. Thanks again for all your effort and support you provide to oracle community 🎉

[sweetmemoriesSR]

Hi Sir, the session 17 is belonging to screen A where first update command ran and 149 is screen B is it correct. This always confuses in many queries, please clarify.

[Vijeshever]

Thumbs down!
You could have easily derived table detail and eventually from the locked session from v$session.

Wonder why YouTubers make it complex for viewers