Identify the time at which you want to execute the maintenance task. Since loading and summarizing data can be a long and resource-intensive process, you may want to schedule it for off-peak hours.
Run maintenance task immediately in this session
Starts the maintenance task immediately after you complete the steps of the wizard.
Submit the maintenance task to the Oracle Job Queue
Enters the maintenance task in the Oracle job queue where it can run in the background, independent of your client computer. In this mode, you can allocate additional processes to speed the job.
Run immediately. The job will run as soon as resources are allocated to it by the job queue.
Run at a future time. The job will run at the scheduled time.
Date and Time
Set the time for starting the maintenance task. Select the area of the time stamp that you want to change (such as the day or hour), then use the arrow keys to increase or decrease the start time.
Maximum number of parallel processes
Enter the number of processes that you want Oracle Database to allocate to this job. Some parts of a job can be parallelized and thus use multiple processes, as follows:
Multiple cubes. Each cube can be loaded and summarized in a separate process. For example, an analytic workspace with five cubes can use up to five processes for loading and summarization.
Partitioned cubes. Each partition can be summarized in a separate process, if each partition has its own composite. For example, an analytic workspace with two small cubes and one large cube with five partitions can use up three processes for the data load and up to seven processes for summarization.
The actual number of processes that you allocate depends on the resources available to you and the time constraints for the job. Oracle Database allocates the specified number of processes regardless of whether all of them can be used simultaneously at any point in the job.
Save maintenance task to script
Creates a SQL script on your local computer or network drive. You can execute the script at any time.
File Name. Type in a file name for the SQL script, or select a directory first.
Copyright © 2003, 2007, Oracle. All rights reserved.