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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
