Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Scripts for Rebuilding Indexes Nightly on Solaris

Scripts for Rebuilding Indexes Nightly on Solaris

From: David Wagoner <dwagoner_at_arsenaldigital.com>
Date: Thu, 06 Sep 2001 08:19:55 -0700
Message-ID: <F001.003853B4.20010906075634@fatcity.com>

<font size=2 color=black

face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: Arial'>Does anyone have any good scripts for rebuilding indexes nightly on Solaris UNIX that they&#8217;d be willing to share?<span style="mso-spacerun: yes">  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 size=2 color=black

face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: Arial'> 

<font size=2 color=black

face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: Arial'> 

<font size=2 color=black

face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: Arial'>Thanks in advance,

<font size=2 color=black

face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: Arial'> 

<font size=2 color=black

face=Arial><span style='font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: Arial'> 

<span

style='font-size:12.0pt;color:black'>David Wagoner<font color=black>

<span

style='font-size:12.0pt;color:black'>Oracle DBA<span style='color:black;mso-color-alt:windowtext'> Received on Thu Sep 06 2001 - 10:19:55 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US