Forum Stats

  • 3,727,079 Users
  • 2,245,318 Discussions
  • 7,852,571 Comments

Discussions

How to monitor hourly application user statistics (data throughput) in Oracle database?

ProDBA
ProDBA Member Posts: 105 Blue Ribbon

We have a requirement to collect the user related statistics of different application users. Which means that, for example, user A performed X number of SELECT statements against the database within past hour, and these statements caused Y GB of data reads and Z GB of data writes.

We know that Oracle automatically collects AWR snapshots every hour.

Can we obtain this information from these snapshots? And how?

Or any suitable method will be thoroughly appreciated.

Tagged:
Sign In or Register to comment.