cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Oracle database insights question - Database locks

Alexander_R_
Advisor

Hello community.

For database user we need DBMS_XPLAN .

So we can see execution plans.

Customer have question:

If we have execution plans can we see Database locks?

If we can, please share to me metrics id (name) for use in Custom graph. Thanks.

Regards,

Alexander


1 REPLY 1

AntonioSousa
Champion

I have got a lot of my answers through the wait times given by Oracle Database Insights. You can check out a good explanation here:

https://www.dynatrace.com/news/blog/oracle-database-insights-early-adopter-release/

The total wait time is also available in the "Time breakdown" tab, but that is for all sessions.

In the Custom Charts, there are no lock statistics for Oracle Database Insights, but there are several wait time series that may be of interest to you.