How to get total no of Disk Reads and Buffer Gets
547796Feb 27 2008 — edited Feb 27 2008Hi
We want to get some information about statistic of a sql that is blocked, so we look up some documents.And we get the following information in a book:
One method to identify which SQL statements are creating the highest load is to compare the resources used by a SQL statement to the total amount of that resource used in the period. For BUFFER_GETS, divide each SQL statement's BUFFER_GETS by the total number of buffer gets during the period. The total number of buffer gets in the system is available in the V$SYSSTAT table, for the statistic session logical reads.
Similarly, it is possible to apportion the percentage of disk reads a statement performs out of the total disk reads performed by the system by dividing V $SQL_STATS.DISK_READS by the value for the V$SYSSTAT statistic physical reads.
But I don't know how to get "The total number of buffer " and "the total disk reads" mentioned above through query V$SYSSTAT table.
Would you please to tell me?
Thank you very much!