Database - RAC/Scalability (MOSC)

MOSC Banner

ALTER INDEX <index_Name> REBUILD ONLINE PARALLEL 6 PCTFREE 10 INITRANS 2;

edited Oct 4, 2019 10:20AM in Database - RAC/Scalability (MOSC) 9 commentsAnswered ✓

ALTER INDEX CS_BMO.WBS_ENTITIES_IDX4 REBUILD ONLINE PARALLEL 6 PCTFREE 10 INITRANS 2;

The above command will really intent to change the default degree of parallelism or it should only for that particular operation.

According to my assumption DOP of 6 for that particular operation, but after executing it I can see it changed default value of degree to 6.

Please help me to understand more on this.

Below support answer:

https://support.oracle.com/epmos/faces/CommunityDisplay?resultUrl=https%3A%2F%2Fcommunity.oracle.com%2Fthread%2F3676074&…

Tedper-Oracle has mentioned that :

"When you issued the ALTER INDEX REBUILD statement, you hadn't really changed the default degree of parallelism.  You'd just requested a DOP of four for that particular operation."

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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center