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).