Database DataWarehousing (MOSC)

MOSC Banner

Rebuild partition index in parallel

edited Jan 13, 2014 2:37PM in Database DataWarehousing (MOSC) 11 commentsAnswered
SQL> SELECT index_name, last_analyzed, degree, status from dba_indexes where table_name in ('EB_READING');

INDEX_NAME                     LAST_ANALYZED        DEGREE                                   STATUS
------------------------------ -------------------- ---------------------------------------- --------
EB_RDG_IDX2                    08-OCT-2013 20:28:43 1                                        N/A
EB_RDG_IDX3                    08-OCT-2013 20:28:48 1                                        N/A
EB_RDG_IDX4                    08-OCT-2013 20:28:53 1                                        N/A
EB_RDG_IDX5                    08-OCT-2013 20:28:58 1                                        N/A
EB_RDG_IDX6                    08-OCT-2013 20:29:02 1                                        N/A
EB_RDG_IDX1                    08-OCT-2013 20:29:03 5                                        VALID

I want to rebuild indexes, 5 indexes are local indexes. Each local index only has 3 partitions, I only need rebuild one partition of 3.

Should I run these scripts to do rebuild partitioned indexes?

alter index energydb.EB_RDG_IDX2 rebuild partition eb_reading_nnulls tablespace index2_1g parallel 8;alter index energydb.EB_RDG_IDX3 rebuild partition eb_reading_nnulls tablespace index2_1g parallel 8;alter index energydb.EB_RDG_IDX4 rebuild partition eb_reading_nnulls tablespace index2_1g parallel 8;alter index energydb.EB_RDG_IDX5 rebuild partition eb_reading_nnulls tablespace index2_1g parallel 8;alter index energydb.EB_RDG_IDX6 rebuild partition eb_reading_nnulls tablespace index2_1g parallel 8;After I rebuild index in parallel 8, should I change the parallel degree into 1? How to do this?Thanks,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center