Check and alter Table Index Parallel degree

1. Check the Degree of Tables in Oracle Enterprise Edition.

set line 200 pages 200
col table_name for a25
select table_name, degree from dba_tables where owner='HR';


2. Change the Degree of Parallelism at Table Level.

alter table owner.table_name parallel (degree 4);


3. Check the degree of indexes of particular table.

select index_name,degree from dba_indexes where table_name='EMPLOYEES';


4. Modify the degree of indexes.

Alter index owner.index_name parallel (degree 4);


5. Change the index degree for all the index present in one table.

select 'alter index '||owner||'.'||index_name||' parallel (degree 4);' from dba_indexes where table_name='EMPLOYEES';


6. Change the table degree for all the tables in schema.

select 'alter table '||owner||'.'||table_name||' parallel (degree 4);' from dba_tables where owner='HR';


7. Change the index degree for all the indexes present in schema.

select 'alter index '||owner||'.'||index_name||' parallel (degree 4);' from dba_indexes where owner='HR';