Thanks for the question, Aidan.
Asked: May 01, 2020 - 8:13 am UTC
Last updated: May 07, 2020 - 4:16 am UTC
Version: 12.2
Viewed 1000+ times
SQL> select distinct stat_name from v$service_stats order by 1; STAT_NAME ---------------------------------------------------------------- DB CPU DB time Main function call count application wait time cluster wait time concurrency wait time db block changes execute count gc cr block receive time gc cr blocks received gc current block receive time gc current blocks received logons cumulative opened cursors cumulative parse count (total) parse time elapsed physical reads physical writes redo size session cursor cache hits session logical reads sql execute elapsed time user I/O wait time user calls user commits user rollbacks workarea executions - multipass workarea executions - onepass workarea executions - optimal
A reader, May 06, 2020 - 6:57 am UTC
Get all the information about database performance in the Database Performance guide.