RE: parallel query waitevents

From: Jeroen van Sluisdam <jeroen.van.sluisdam_at_vrijuit.nl>
Date: Fri, 9 Apr 2004 16:24:35 +0200
Message-ID: <727A513477946E4380C23DD63C36FCC026BB3B@pedro.vrijuit.nl>

SQL> show parameter parall

NAME                                 TYPE        VALUE


------------------------------------ -----------

------------------------------

fast_start_parallel_rollback         string      LOW
log_parallelism                      integer     1
parallel_adaptive_multi_user         boolean     FALSE
parallel_automatic_tuning            boolean     FALSE
parallel_execution_message_size      integer     2152
parallel_instance_group              string
parallel_max_servers                 integer     5
parallel_min_percent                 integer     0
parallel_min_servers                 integer     0
parallel_server                      boolean     FALSE
parallel_server_instances            integer     1

NAME                                 TYPE        VALUE


------------------------------------ -----------

------------------------------

parallel_threads_per_cpu             integer     2
recovery_parallelism                 integer     0

But see my own repy also problem was due to create table with parallel option enabled and degree was specified on default. Didn't check everything developers did, I know should do that !!

Tnx,

Jeroen

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

Received on Fri Apr 09 2004 - 10:39:26 CDT