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@xxxxxxxxx> 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.'
