DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: logical reads

  1. #1
    Join Date
    Jul 2003

    logical reads

    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

  2. #2
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.