Parallel Degree

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


Other related posts: