|Oracle® OLAP DML Reference
10g Release 1 (10.1)
Part Number B10339-02
When an OLAP DML statement is executed through SQL, using the POUTFILEUNIT option enables you to see the work that the statement is doing as it progresses instead of waiting until the execution of the SQL call is complete.
Note:Because POUTFILEUNIT does not have a default setting, this information is not collected unless you set POUTFILEUNIT in your session.
POUTFILEUNIT = fileunit
Specifies a destination, such as an open disk file, to which Oracle OLAP sends information on the progress of an operation. The fileunit can be the value of the OUTFILEUNIT option or the results of the FILEOPEN function.
Progress of the verification of the hierarchy of a dimension
Progress of the building of intermediate computation structures
The execution of the allocation or aggregation
Errors or anomalous behavior that Oracle OLAP encounters in allocating or aggregating the source data to the target variable cells, such as skipped deadlocks in an allocation.
Example 19-36 Using FILEOPEN to Open a File
The FILEOPEN command opens a file named
progress.txt in the
userfiles directory object and returns the file handle to the POUTFILEUNIT option. The file receives status messages from the AGGREGATE command. When the aggregation is complete, the FILECLOSE command closes the file.
POUTFILEUNIT=FILEOPEN('userfiles/progress.txt' WRITE) AGGREGATE sales units USING gpct.aggmap FILECLOSE POUTFILEUNIT
Example 19-37 Viewing Progress in OLAP Worksheet
The following statement sets POUTFILEUNIT to the current outfile destination. When the current outfile destination is the OLAP Worksheet window, remember that you cannot do other work in your session until the operation completes.