Re: delayed logging block cleanout

From: <Jared.Still_at_radisys.com>
Date: Wed, 26 May 2004 14:13:09 -0700
Message-ID: <OF25669CC4.DEE88167-ON88256EA0.00745EDC-88256EA0.00748F37@radisys.com>

Diego,
The d_l_l_c parameter does not delay the cleanouts, just the logging of them.

See http://www.ixora.com.au/q+a/cr.htm

Jared

> Hi List,
> I was showing another DBA how delayed block clean out mechanism
> works when I found this....
>
>
> Oracle 8.0.6.3.0
> delayed_logging_block_cleanouts=TRUE (default)
>

...
> fsl: 0 fnx: 0x0 ver: 0x01
>
> Itl Xid Uba Flag Lck Scn/Fsc
> 0x01 0x0002.05f.0001454f 0x00822873.0b8f.29 C--- 0 scn
0x0698.b1acfbcc
>
> why did this block get cleaned out? . I just executed a query not a
> DML command.
> I then checked every table block and all of them got cleaned out by
> the query shown above.
> AFAIK in Oracle 7 and Oracle 8 version after executing a query this
> block should not have been cleaned out unless
> delayed_logging_block_cleanouts=FALSE
>
> (I have also tested this in an Oracle 7 instance, and I got the same
result)
>
> Please shed some light on this.
>
> Thanks
> Diego.
>

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 Wed May 26 2004 - 16:10:49 CDT