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!

How to diagnose the bottleneck in database?

ronald_2017Jan 11 2021

Hi All,

Oracle 19c

Today our systems have almost come to a stopping point in a period of time. We had to restarted the db. However, after restart the problem continued for a while.
What do you usually do in these kind of situations? Should I check the active session history in order to find the wait event? If so, do you have a script for this? What do you recommend?

Thanks in advance

Comments
Post Details
Added on Jan 11 2021
7 comments
696 views