Exadata General (MOSC)

MOSC Banner

Index Creation Taking long time -cell multiblock physical read

edited Oct 26, 2013 2:47AM in Exadata General (MOSC) 1 commentAnswered
 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 :-

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