Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Blocking session info in OEM

BlueSkiesNov 22 2023 — edited Nov 22 2023

DB version : 19c
OEM version : 13.4

In OEM, I see the following blocking session in a prod DB.

As I understand, session with SID 5631 and serial# 1271 is blocking the session with SID 6460 and serial# 42017.

What exactly are P1 and P2 values shown for the session with SID 6460 and serial# 42017 ?

In Chrome, to get a magnified view of the picture, right click on the picture and choose, ‘Open image in new tab’

Comments
Post Details
Added on Nov 22 2023
1 comment
393 views