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.