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
Received on Wed Aug 30 2000 - 06:04:51 CDT
