Re: delayed logging block cleanout
- From: Jared.Still@xxxxxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 26 May 2004 14:13:09 -0700
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
