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

Thread: consistent changes.

  1. #1
    Join Date
    Jan 2000
    Location
    san jose
    Posts
    149
    in v$sysstat
    there are a parameter named "consistent changes"

    the oracle explaination is:
    Number of times a user process has applied rollback
    entries to perform a consistent read on the block.
    Work loads that produce a great deal of consistent changes
    can consume a great deal of resources. The value of this
    statistic should be small in relation to the "consistent gets"
    statistic.

    can somebody say more about that?
    if this one is big, what should we do?
    how and why this one go big?

  2. #2
    Join Date
    Jun 2001
    Posts
    9
    Hi,
    You are right. That is number of times a user process gets the data from rollback segments. This number will increase depends on number of updations and deletions. You can't restrict this value. Because when you are updating or deleting a row, the corresponding before images will be placed in the rollback segments. Before the updation or deletion completes the commit or rollback If any other tx try to read the same page, then it reads the data from the rollback segements.
    Even if u have enough space in buffer cache, it will do the same. this process doesn't effect the performance.

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