Skip Headers
Previous
Previous
 
Next
Next

About Maintenance Logs

The first time you load data into a cube or cube dimension, OLAP creates several logs. These logs are listed under OLAP Reports in the Reports navigator. They are also stored in tables in the same schema as the analytic workspace:

These logs enable you to track the progress of long running processes, then use the results to profile performance characteristics. They provide information to help you diagnose and remedy problems that may occur during development and maintenance of a cube. They also help diagnose performance problems in querying cubes. You can query the tables using any SQL interface.

You can also run the $ORACLE_HOME/olap/admin/utlolaplog.sql script to create the build log with some useful views.


See Also:

DBMS_CUBE_LOG entry in Oracle Database PL/SQL Packages and Types Reference.