Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Consistent reads strange behavior.

Consistent reads strange behavior.

From: <J.Velikanovs_at_alise.lv>
Date: Sun, 10 Oct 2004 22:44:51 +0300
Message-ID: <OFB0D60856.FE5925DB-ONC2256F29.006C3293-C2256F29.006C9FC1@alise.lv>


Hi All,
Take a look on the testcase below.
Couple of things seems strange to me in this testcase: 1. Step Nr. 5. Why Oracle can’t use already created copy of the block during step Nr.4?
2. Step Nr. 4. Why there “52 redo size” during the CR? Anybody have idea?

Jurijs



Test case

Tested on 9.2.0.4/5 Win32/Linux

         N


         1

Statistics



          7  consistent gets
          0  redo size

         N


         1

Statistics



      10008  consistent gets
         52  redo size

         N


         1

Statistics



      10008  consistent gets
         52  redo size

         N


     10000

Statistics



          7  consistent gets
          0  redo size


--

http://www.freelists.org/webpage/oracle-l Received on Sun Oct 10 2004 - 14:42:22 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US