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

How can I detect Lock tables in Oracle??

luis_navia
Frequent Guest

I'm facing the problem to detect lock tables, the application goes down twice and I couldn't detect them with Dynatrace SaaS. The database is Oracle RAC 12c.

Can you help me?



5 REPLIES 5

skrystosik
DynaMight Guru
DynaMight Guru

From dynatrace (only) you will not have access to such informations. You can see only ORA exceptions on transactions.

https://www.dynatrace.com/support/help/how-to-use-dynatrace/databases/analysis/database-insights/

this feature may give you some extra insights about your DB. But in most cases help of DBa would be priceless.

Sebastian


Regards, Sebastian

I know. On the other hand I see that Oracle RAC is not supported yet.



You’re right, it’s probably because of how engine works. In general I would look for slow or failed queries in Dynatrace in timeframe near locks. Then you should send them to DBA for analysis I think.

Sebastian


Regards, Sebastian

In this case I need to reconfigure database failures detection to notify problem near to lock. Is that right?


If you want to be alerted in such case you will be because of failure rate and slowdown on DB. You don’t need to configure anything more. But when you want just analysis you can filter data you already have.

Sebastian


Regards, Sebastian

Featured Posts