Oracle Database Discussions

Hi Guru

When we do an Coleasce of Index, Will the Parallel be used.

Also is the below statements same?

a) alter index "SAPAPO"."/1OM/SSTO2STT21044" COALESCE PARALLEL (DEGREE 25);

and

b) alter index "SAPAPO"."/1OM/SSTO2STT21044" COALESCE PARALLEL 35;

When i used a),
SQL> select index_name,degree from dba_indexes where index_name='/1OM/SSTO2STT21044';

INDEX_NAME DEGREE
------------------------------ ----------------------------------------
/1OM/SSTO2STT21044 25

But when i used b, i don see the degree updated. Will the coalesce use 35 threads?

Thanks
Ram