Parallel Degree
From: RAAZ <yoursraju007_at_gmail.com>
Date: Tue, 1 Jul 2008 10:55:26 -0400
Message-ID: <7f411f4e0807010755g4d9aba97ia320615156b0ec51@mail.gmail.com>
Date: Tue, 1 Jul 2008 10:55:26 -0400
Message-ID: <7f411f4e0807010755g4d9aba97ia320615156b0ec51@mail.gmail.com>
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-lReceived on Tue Jul 01 2008 - 09:55:26 CDT