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

Other related posts: