Re: Delayed Block Cleanout is not happening

Hi Gopal,

There appears to be some error with this URL.

Can you send it as an attachment...

Regards,

K Gopalakrishnan wrote:

> Hi !
>
> It is very simple and fairly stratight forward. There
> is a tip in Jonathan Lewis Site
> http://jlcomp.demon.co.uk.
>
> Regards,
> K Gopalakrishnan
> Bangalore, INDIA
>
> --- "Joseph S. Testa" <teci_at_oracle-dba.com> wrote:
> > Ok 'm always willing to learn, how did you do the
> > data block dump?
> >
> > joe
> >
> > K Gopalakrishnan wrote:
> > >
> > > Hi All...
> > >
> > > I have created a table and inserted one row. Now I
> > > have dumped the datablock and here is the ITL
> > Entry
> > >
> > > Itl Xid Uba
> > Flag
> > > Lck Scn/Fsc
> > > 0x01 0x0002.012.00000012 0x00c00b8f.0037.01
> > ----
> > > 1 fsc 0x0000.00000000
> > >
> > > Now I have updated a row in that table..(but
> > didn't
> > > commmit..) Here is that ITL entry
> > >
> > > Itl Xid Uba
> > Flag
> > > Lck Scn/Fsc
> > > 0x01 0x0002.012.00000012 0x00c00b8f.0037.01
> > --U-
> > > 1 fsc 0x0000.00009131
> > >
> > > Here the flag is --U- As expected...And i did a
> > > commit.
> > > And the ITL falg has not changed..
> > >
> > > I forced a block cleanout by doing a full table
> > scan
> > > of that table. But still the ITL flag is --U-
> > >
> > > My question is WHEN EXACTLY the block clean out is
> > > done and how do i trace that?
> > >
> > > The version is 8.0.3 and NT 4.0 (SP5) If that
> > matters.
> > >
> > > __________________________________________________
> > > Do You Yahoo!?
> > > Yahoo! Mail - Free email you can access from
> > anywhere!
> > > http://mail.yahoo.com/
> > > --
> > > Author: K Gopalakrishnan
> > > INET: kaygopal_at_yahoo.com
> > >
> > > Fat City Network Services -- (858) 538-5051
> > FAX: (858) 538-5051
> > > San Diego, California -- Public Internet
> > access / Mailing Lists
> > >
> >
> --------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of
> > 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > > (or the name of mailing list you want to be
> > removed from). You may
> > > also send the HELP command for other information
> > (like subscribing).
> >
> > --
> > Joe Testa http://www.oracle-dba.com
> > Oracle 8i documentation online
> > http://www.oracle-dba.com/oracle-docs
> > --
> > Author: Joseph S. Testa
> > INET: teci_at_oracle-dba.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX:
> > (858) 538-5051
> > San Diego, California -- Public Internet
> > access / Mailing Lists
> >
> --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (or the name of mailing list you want to be removed
> > from). You may
> > also send the HELP command for other information
> > (like subscribing).
>
> =====
> With Regards !
> K Gopalakrishnan
> -----------------------------------------------------------
> #489,EastEnd Main Road,
> Jayanagar IX Block East,
> Bangalore-560069, INDIA
> Ph # + (91)-(80)- 6543672
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Mail - Free email you can access from anywhere!
> http://mail.yahoo.com/
> --
> Author: K Gopalakrishnan
> INET: kaygopal_at_yahoo.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Thu Aug 31 2000 - 08:31:39 CDT