How to show disk_reads of current sql_id
Hello,
How to found the consumption of the current "sql_id" ? specialy for "disk_reads"
v$sql contains a cumulative statistics for sql_id.
v$session doesn't contain these statistics.
v$sessmetric contains only the "number of physical reads" not "the number of physical blocks readed"
Any help.
My final aim, sid to list the sid that consumes a huge disk_reads.
Thanks in advance.