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 -----
From: Ronen Levit <ronen.levit_at_talmai.com> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Monday, September 11, 2000 10:41 AM Subject: Building index using parallel threads

> 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).
Received on Mon Sep 11 2000 - 17:28:20 CDT