Re: Parallel Degree

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:

> Fellas,
>
> 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; )
>
>
> Thanks,
> Raj M
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

--
http://www.freelists.org/webpage/oracle-l