"consistent_gets is the number of times a consistent read was requested for a block"

"db_block_gets tracks the number of blocks obtained in CURRENT mode"



And a CONSISTENT READ would be....? From Where?

You see, I thought DB BLOCK GETS were from the DB_Buffer_Cache and Consistent reads were from the Rollback Segments and Physical Reads are from the Disk. Which I suppose is strange since Rollback Segments reside on disk.

Hmmm... more feedback required please.

Cheers,