On several existing and running Oracle instances I would like to measure server activity.
My wish is to monitor:
* the number of transactions per time interval
* the number of executed reads per time interval
In my undestanding, a SELECT statement will not count as a transaction as it is not modifying anything on the database. Is this assumption correct? If yes, I need to distinguish between transactions and read-only selects.
How can I measure / monitor those two numbers?
Thanks & regards,