Index Creation Taking long time -cell multiblock physical read
Hi,
We are creating the index on the tables after the ETL Load . For are creating the indexes on the Parallel . Somehow this is taking time and most of time DB is waiting on the 'cell multiblock physical read' . We are creating index in parallel . Customer is wonder why Exadata is waiting on the Cell waits .
Command which we are using to Create index :-
alter session force parallel ddl parallel 24;
alter table DTL_TRAN_MA add constraint PK_DTL_TRAN_MA primary key (ARNG_ENT_NO, ARNG_TYP_CD, ARNG_NO, PST_DT, PST_ORD) using index local;
Here are Top 5 wait events :-
0