Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Scripts for Rebuilding Indexes Nightly on Solaris
<FONT face=Arial color=#0000ff
size=2>Nightly? That is a lot. Are you really entering that much
data on a daily basis?
<FONT face=Tahoma
size=2>-----Original Message-----From: David Wagoner
[mailto:dwagoner_at_arsenaldigital.com]Sent: Thursday, September 06,
2001 8:57 AMTo: Multiple recipients of list
ORACLE-LSubject: Scripts for Rebuilding Indexes Nightly on
Solaris
<FONT face=Arial color=black
size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">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?<SPAN
style="mso-spacerun: yes"> I suspect the cron job will be the
favorable answer.
<FONT face=Arial color=black
size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">
<FONT face=Arial color=black
size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">
<FONT face=Arial color=black
size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">Thanks
in advance,
<FONT face=Arial color=black
size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">
<FONT face=Arial color=black
size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">
<SPAN
style="FONT-SIZE: 12pt; COLOR: black">David Wagoner<FONT color=black><SPAN style="COLOR: black; mso-color-alt: windowtext">
style="FONT-SIZE: 12pt; COLOR: black">Oracle DBA<FONT color=black><SPAN style="COLOR: black; mso-color-alt: windowtext">Received on Thu Sep 06 2001 - 10:48:19 CDT
![]() |
![]() |