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

Oracle databases Problem

lazaroyadrian_p
Organizer

Hi all,
every day on the systems I detect a slowdown that lasts about 15 minutes.
Analyzing I found that the number of sessions on the database goes from 20 to about 100 and the number of user calls drops until the problem is solved by itself.

I'm not an expert database, you can explain what would measure the metric "Other" of the graph Time Spent Breakdown.

It may seem a very general question, but what do you think I should have administrators check?

Thanks and Regards,
Lazarodb.jpg


2 REPLIES 2

david_n
Inactive

Hello Lazaro,

Have you tried drilling down to the Purepaths for that timeframe and seeing what DB activity there may be for that time frame? You could also go to the Database dashlet and look at the response time hotspots and execution hotspots to get a handle on what your DB is spending its time working on.

https://www.dynatrace.com/support/doc/appmon/application-monitoring/appmon-client/dashlets/database-dashlet/

Thanks,

David Nicholls


Hello David,
Yes, we have already tried and we see that the execution times rise, but it seems to be an effect and not the cause of the problem.

I would be interested to understand what measures the metric "other".

Regards,
Lazaro