SELECT a.NAME "Pool", a.physical_reads, a.db_block_gets, a.consistent_gets,
(SELECT ROUND ( ( 1
- (physical_reads
/ (db_block_gets + consistent_gets)
)
)
* 100
)
FROM v$buffer_pool_statistics
WHERE db_block_gets + consistent_gets != 0 AND NAME = a.NAME)
"Ratio"
FROM v$buffer_pool_statistics a;