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

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

RE: Scripts for Rebuilding Indexes Nightly on Solaris

From: Kimberly Smith <kimberly.smith_at_gmd.fujitsu.com>
Date: Thu, 06 Sep 2001 08:48:19 -0700
Message-ID: <F001.003855B4.20010906085714@fatcity.com>

<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&#8217;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">

<SPAN
  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

Original text of this message

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