Analyze database activity using v$log_history

Cyrille Modiano

OCP Oracle DBA in Montreal at DBSoft

The v$log_history view contains important information on how application’s users use the database , this view can help you define periods with the most activity in the database.

v$log_history queries

You can adapt the query to your needs, you just have to change the way you format the date to be able to drilldown to the precision you want.

This one gives the following output :

You can find out which day of the week is the most active. You can also have a day to day analysis for the last month :

here is the output :

 

You can also drilldown to hours in the day :

Here the output :

Be creative 🙂

Leave a Reply