Analyze database activity using v$log_history

Cyrille Modiano

OCP Oracle DBA in Montreal at Desjardins

Latest posts by Cyrille Modiano (see all)

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 🙂

2 thoughts on “Analyze database activity using v$log_history

    1. Hi,

      This analysis allows you to understand how your database is used, what are the most active hours and which ones have the least activity.
      This information allows you to:

      – Know when there is unusual activity on your database based on the usual usage data.
      – know at what hours it is possible to do maintenance by impacting the least users.

      Cyrille

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.