Re: Parallel Degree
Date: Tue, 1 Jul 2008 10:26:52 -0500
I believe the parallel degree on a partition is going to be the same degree as the table on a whole.
the init parameters are parallel_min_servers and parallel_max_servers
You can also alter table/index noparallel.
On Tue, Jul 1, 2008 at 9:55 AM, RAAZ <yoursraju007_at_gmail.com> wrote:
> Can you answer the following for me ?
> How to find out parallel degree on partitions of the table ?
> (dba_tab_partitions doesn't have degree column :( )
> How to alter the degree of the partion of the table/indexe ?
> How to alter the degree of the Mview ?
> Is there any init parameter/event in Oracle that disables parallelism
> at the database level ? (I know there is one at session leve, alter
> session disable parallel query; )
> Raj M
-- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.' -- http://www.freelists.org/webpage/oracle-lReceived on Tue Jul 01 2008 - 10:26:52 CDT