| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Scripts for Rebuilding Indexes Nightly on Solaris
Try the script at the bottom of the page at:
http://www.revealnet.com/newsletter-v2/rebuild.htm <http://www.revealnet.com/newsletter-v2/rebuild.htm>
It will find indexes that need rebuilding and generate a script containing
the
ALTER INDEX REBUILD statements for those indexes that need rebuilding.
You can read the article while waiting for the script to complete ;-)
HTH
Ed
-----Original Message-----
Sent: Thursday, September 06, 2001 12:57 PM
To: Multiple recipients of list ORACLE-L
Nightly? That is a lot. Are you really entering that much data on a daily basis?
-----Original Message-----
Sent: Thursday, September 06, 2001 8:57 AM
To: Multiple recipients of list ORACLE-L
Does anyone have any good scripts for rebuilding indexes nightly on Solaris UNIX that they'd be willing to share? Also, in your experience is it better to run this through UNIX cron jobs than using the Oracle OEM job scheduler? I suspect the cron job will be the favorable answer.
Thanks in advance,
David Wagoner
Oracle DBA
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Sep 06 2001 - 11:27:04 CDT
 |
 |