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!

Find historical blocking and locking session from Statspack/Oracle Standard Edition

Hemant SakpalApr 17 2023

Hello All,

OS: RHEL

DB:19.18 SE

I can see that there are many blocking session in statspack top wait events but when I try to find out the exact sql which is causing this I am unable to do so.

I am aware how this can be done from AWR but in statspack/standard edition I am not quite sure how we can do this.

Thanks,

Hemant Sakpal

This post has been answered by Mark J. Bobak-Oracle on Apr 17 2023
Jump to Answer
Comments
Post Details
Added on Apr 17 2023
4 comments
5,757 views