Hello DBAs:
What is the definition of consistent gets and db_block_gets?
Is it measured in blocks or number of trips Server process takes to buffer since Consistent gets and db_block_gets are logical reads.
Thanks, ST2003
Printable View
Hello DBAs:
What is the definition of consistent gets and db_block_gets?
Is it measured in blocks or number of trips Server process takes to buffer since Consistent gets and db_block_gets are logical reads.
Thanks, ST2003
Hi, I think you get it form sql*plus autotrace,
consistent gets is logical io in consistent state, while db_block_gets are logical io in current mode.
You can view asktom.oracle.com to get a more detailed explanation.