Parallel Degree

From: RAAZ <>
Date: Tue, 1 Jul 2008 10:55:26 -0400
Message-ID: <>


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

Received on Tue Jul 01 2008 - 09:55:26 CDT

Original text of this message