RE: what are 'no work - consistent read gets'

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Tue, 18 May 2004 10:37:55 -0400
Message-ID: <4C9B6FDA0B06FE4DAF5918BBF0AD82CF03B454E8@bosmail00.bos.il.pqe>

They go hand-in-hand with the other types of consistent gets.

When Oracle does a consistent get on a block, it may need to rollback changes, or not, and it may need to clean out the block, or not. The following statistics are available in the statistics viewa:

no work - consistent read gets
cleanouts only - consistent read gets
rollbacks only - consistent read gets
cleanouts and rollbacks - consistent read gets

So, it's just Oracle accounting for the different types of consistent read gets, and how many of each type it did.

-Mark

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of ryan.gaffuri_at_cox.net Sent: Tuesday, May 18, 2004 9:06 AM
To: oracle-l_at_freelists.org
Subject: what are 'no work - consistent read gets'

Didn't see any reference on metalink?=20

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/

FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com


----------------------------------------------------------------

To unsubscribe send email to:  oracle-l-request_at_freelists.org

put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Tue May 18 2004 - 09:41:09 CDT