What is database block gets and consistent gets?

Questions by supportdba8910

Showing Answers 1 - 1 of 1 Answers

santosh Panigrahi

  • Jul 12th, 2009
 

Database Block Gets: Finding matching data block in database buffer cache.


Consistent Gets: When data need to fetch are valid or available in buffer. It means data are not being modified when again executing same
SQL statement. In short This is a read of buffer cache, to retrieve the block in consistent state.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions