RE: is this block cleanout ?

list / Gopal, this is not a direct load, the app does normal insert .. 20+ million of them !!
i checked the block cleanout parameter .. and it does default to TRUE in verion 7.3+

now.. .can turning this parameter to FALSE will speed up the FTS after the insert.. but then
the inserts will take longer !! right ? because each insert will do the cleanout too ..

> ----------
> From: K Gopalakrishnan[SMTP:kaygopal_at_yahoo.com]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Saturday, October 19, 2002 10:18 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: is this block cleanout ?
>
> Stephane:
>
> INSERTs certainly associated with block cleanout. But the issue here
> Rahul is doing a Direct load and this does not work as expected in earlier
> versions (7.3 and below). They do not use ITLs as in the regular inserts
> and there used be some bugs in 7.x versions were ITLs are not used in
> regular fashion, and this results in incorrect count(*) during the
> direct loads (something similar to Dirty read).
>
> These bugs are fixed in 8i and above versions where Direct inserts
> are also behave like regular inserts. But in any case Inserts are also
> associated with block cleanouts.
>
>
>
> Best Regards,
> K Gopalakrishnan
>
>
>
>
> -----Original Message-----
> Faroult
> Sent: Saturday, October 19, 2002 6:44 AM
> To: Multiple recipients of list ORACLE-L
>
>
> "Deshpande, Kirti" wrote:
> >
> > That's sounds about right...
> >
> > - Kirti
> >
> > -----Original Message-----
> > Sent: Saturday, October 19, 2002 3:48 AM
> > To: Multiple recipients of list ORACLE-L
> >
> > when i do a count(*) an a 1.2GB table, just after an app finishes
> inserting
> > 20 million records
> > i can see from iostat that, that disk is being read as well as written
> to
> > !!!
> >
> > the only reason i can think of WRITES being performed while being READ
> is
> > the block cleanout is being performed by the count(*) !!
> >
> > i would appreciate if anyone could explain further !
> >
> > regards
> >
> > PS: 7.3.2 on AIX, the file is raw and async_io is true
> >
>
> Kirti,
>
> This is also what I thought, but wouldn't a 'count(*)' just use the
> primary key? (Unless it is a 1.2 G unindexed table). Morover, in my mind
> a block cleanout is associated with a delete, not an insert. Might it be
> say the cleanout of temporary segments after say a direct load ?
>
> Regards,
>
> Stephane Faroult
> Oriole Software
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Stephane Faroult
> INET: sfaroult_at_oriole.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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).
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: K Gopalakrishnan
> INET: kaygopal_at_yahoo.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rahul
  INET: rahul_at_ratelindo.co.id

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).