Re: Fasten huge index rebuild - How To ?

Hi Niall/Zoran , this was the reply i got from him.
***************************************************************************=
*

It maybe hard to tell because when our database is running daily jobs, the majority wait events are:
db file sequential read , direct path read PX related events , i/o slave wait , db file scattered read SQL*Net message to/from dblink

When we re-create the index, all other jobs will not be running. We can still assume the same major events as in running daily jobs, except the "SQL*Net message to/from dblink"
***************************************************************************=
***

thanx guys for all ur help.

Regards,
Prem.

--
http://www.freelists.org/webpage/oracle-l