Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

Ali Raza MemonFeb 25 2021

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.

Comments

Post Details

Added on Feb 25 2021
0 comments
148 views