Re: Fasten huge index rebuild - How To ?
- From: Prem Khanna J <premjhere@xxxxxxxxx>
- To: zoran_martic@xxxxxxxxx, niall.litchfield@xxxxxxxxx
- Date: Thu, 19 May 2005 19:40:23 +0530
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
