set linesize 200 select name "Buffer Pool",db_block_gets "Db Block Gets",consistent_gets "Consistent Gets",physical_reads "Physical Reads",physical_writes "Physical Writes", ((1 - (physical_reads/(db_block_gets + consistent_gets))) * 100) "Hit Ratio" from v$buffer_pool_statistics;