Re: Building index using parallel threads

From: Davide Bellesi <davide.bellesi_at_visto.com>
Date: Tue, 12 Sep 2000 03:56:45 -0700
Message-Id: <10617.116709@fatcity.com>

Hi ,

  does anybody can help me ???

I don't know the way to reduce misses on "parallel query alloc buffer".

I'm using Oracle 8.1.5 and the init parameters are :

NAME                                VALUE
----------------------------------- --------------------
parallel_server                     FALSE
parallel_server_instances           1
recovery_parallelism                0
fast_start_parallel_rollback        LOW
parallel_broadcast_enabled          FALSE
parallel_adaptive_multi_user        TRUE
parallel_threads_per_cpu            2
parallel_automatic_tuning           TRUE
optimizer_percent_parallel          0
parallel_min_percent                0
parallel_min_servers                0
parallel_max_servers                160
parallel_instance_group
parallel_execution_message_size     4096

Thanks
Davide

-----Original Message-----
From: Tom Pall tom_at_cdproc.com
Sent: Mon, 11 Sep 2000 15:31:28 -0800 To: ORACLE-L_at_fatcity.com
Subject: Re: Building index using parallel threads

Yes,

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

> Hi,

>=20
> 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 usi=
ng
> one thread?

>=20

> Ronen Levit
> Database group manager
> Talmai
> Tel: +972 8 9460606 #212
> Fax: +972 8 9460705
> Cell: +972 52 448699

>=20
>=20

> --=20
> Author: Ronen Levit
> INET: ronen.levit_at_talmai.com

>=20


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

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

_________________________________________________________________________=

__
Visit http://www.visto.com/info, your free web-based communications cente= Received on Tue Sep 12 2000 - 05:56:45 CDT