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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: First 17 updated records disappeared from REDOLOG files …

Re: First 17 updated records disappeared from REDOLOG files …

From: Jurijs Velikanovs <j.velikanovs_at_gmail.com>
Date: Fri, 24 Feb 2006 00:19:35 +0000
Message-ID: <d6f0def50602231619p3f8a9a74s3ca880064f488590@mail.gmail.com>


> > with _in_memory_undo=false
> > true => 6656 KB
> > false => 7168 KB
> > supplemental logging => 10752 KB
> > This is seems understandable.
>
> How did you test the redo generation? I saw some strange things happening,
> that with the same test case occasionally way more or less of redo was
> generated (which means that my test case wasn't adequate enough).
The database have beed 100% dedicated for a test (single user mode). Before and after each update I have made logswitch. Have noted the generated archive redo file size. (I know I could use v$sesstat, but in that case the size of redo wasn't the primary attantion object)

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Feb 23 2006 - 18:19:35 CST

Original text of this message

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