Oracle database insights question - Database locks

[Romanenkov_Alex]

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

[AntonioSousa · Accepted solution]

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.