Parallel Degree

  • From: RAAZ <yoursraju007@xxxxxxxxx>
  • To: oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 1 Jul 2008 10:55:26 -0400


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

Other related posts: