Re: 10.2.0.2 dbua changing parallel_max_server?

From: Don Seiler <don_at_seiler.us>
Date: 15 May 2006 12:39:25 -0700
Message-ID: <1147721965.482236.252840@i39g2000cwa.googlegroups.com>

FYI: SQL> show parameter parallel_threads_per_cpu;

NAME                                 TYPE        VALUE


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

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

parallel_threads_per_cpu             integer     2

SQL> show parameter cpu_count;

NAME                                 TYPE        VALUE


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

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

cpu_count                            integer     8

SQL> show parameter pga_aggregate_target;

NAME                                 TYPE        VALUE


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

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

pga_aggregate_target                 big integer 24M

Received on Mon May 15 2006 - 14:39:25 CDT