Scheduling database index rebuilds

Log into the AS3000 Database Server as user oracle.

To open the crontab file for editing, type:

crontab -e

Go to the end of the file and add a line similar using the following syntax:

mm hh * * day /usr/mvf/bin/index_rebuild

• mm—specifies what minute to start the script

• hh—specifies what hour to start the script, in 24 hour clock format

• day—specifies what day of the week run the script, where 0=Sunday, 1=Monday, ..., 6=Saturday

For example, to run index_rebuild every Friday night starting at 11:15 pm, enter the following line:

15 23 * * 5 /usr/mvf/bin/index_rebuild

Save the crontab file and exit.

Open Control Panel.

Select Scheduled Tasks.

Click Add Scheduled Task.

In the Scheduled Task wizard, click Next.

Click Browse and select C:\mvf\bin\index_rebuild, then click Next.

Type a name for the task and select Weekly. Click Next.

Select the appropriate start time and day of the week. Click Next.

To confirm, click Finish.

Right-click the newly created scheduled task and select Properties.

Change the Run line to

c:\cygwin\bin\bash.exe -c 'export ORACLE_HOME=C:/oracle/product/10.2.0/db_1; c:/mvf/bin/index_rebuild'