Perform maintenance activities.
alter system {gc|javagc|allow adminonly|allow all|prepare for migration|populate reporting schema|reconcile active response|reconcile response number|set datetime to datetime force|set maintenance mode|unset datetime|unset maintenance mode|freeze datetime at datetime|invoke script template script_name|invoke application hook|execute tasks in group group_name|add task group group_name command command user user_name onfailure boolean_token|delete tasks in group group_name|reset|restructure|solve constraint using rule rule rule_name|enable email reader|disable email reader|purge all closed scenarios|purge closed scenarios older than number days}
cube_name—Name of the cube
number—Any valid number
datetime—Any valid date/time
script name—Script template name
command—Command to execute
user_name—Name of the user
boolean_token—True or false
group_name—Model group name
rule_name—Constraint rule name
The alter system command includes the following maintenance activities:
Garbage collection—Forces the Java server to run garbage collection at the end of large batch calculations or at the end of a script.
Prepare for migration—Exports all metadata and data to the file system, including the data in the row sources and the user-entered data in the cubes. Derived data is not exported.
Migration—Brings in the information from exported files and uses isadmin commands to import the model back into the system. The following command imports user-entered values in cube cells back into the cubes.
load update cube "DriveDemand"
This command looks for cube-name-XXXX.csv files in directory export-dir/migration/data, where XXXX is a counter and it starts from 0000. Cube data is exported to export-dir/migration/data with a maximum of 50000 rows to a file.
See Migration Scripts for a sample migration script.
Populate reporting schema—Integrates Integrated Operational Planning with Oracle Business Intelligence Enterprise Edition. The command creates view definitions on OIOP schema tables. The data is used by Oracle Business Intelligence Enterprise Edition to generate reports and dashboards.
Set/unset datetime—Sets/unsets the user provided date.
Set/unset maintenance mode—In administrative mode, you are not allowed logins to the user interface, even by an administrator. Set the system to single-user mode during large data load and calculations, and to normal mode at the end of the script. Disable e-mail at the beginning of a script and enable it again at the end.
Freeze datetime—Freezes the application date/time.
Invoke script template—Invokes the script template.
Execute tasks—Executes the tasks.
Add task—Adds a task in the group.
Delete tasks—Deletes tasks from the application.
Restructure—Pushes the object definitions from the shadow schema to the base schema.
Solve constraint—Uses Custom Java Code Commands to solve constraints.
Enable/disable e-mail reader—Enables/disables the e-mail reader. Disable the e-mail reader while running large calculations.
Purge closed scenarios—Reduces the clutter in the user interface and improves performance.
alter system gc alter system purge all closed scenarios alter system purge closed scenarios older than 30 days alter system set maintenance mode alter system disable e-mail reader