Re: Building index using parallel threads

Thanks Tom.

I'm not sure that I'm having the same problem - I'm not using the parallel option, but having few threads of my own Java program that perform simple bulk inserts into the table.
Should this problem appear in the this situation too?

Anyway, is the a way to reduce the number of extents in such process? Giving an higher INITRANS parameter will help?

Ronen.

-----Original Message-----
From: Tom Pall [mailto:tom_at_cdproc.com]
Sent: Tuesday, September 12, 2000 1:31 AM To: Multiple recipients of list ORACLE-L Subject: Re: Building index using parallel threads

Yes,

This is the drawback to parallel object creation. Each PQ slave writes out its own extents. This can result in more extents than would be needed if the
object were not created in parallel.
----- Original Message -----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Monday, September 11, 2000 10:41 AM

> Hi,
>
> Did any of you tried to insert data into tables using few threads (>2) and
> got an index that uses more space than it would use if it was built using
> one thread?
>
> Ronen Levit
> Database group manager
> Talmai
> Tel: +972 8 9460606 #212
> Fax: +972 8 9460705
> Cell: +972 52 448699
>
>
> --
> Author: Ronen Levit
> INET: ronen.levit_at_talmai.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).

-- 
Author: Tom Pall
  INET: tom_at_cdproc.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).