Display Tablespace (Aggregate Storage)

The MaxL display tablespace statement for ASO mode helps you view details about a tablespace belonging to an Essbase aggregate storage database.

Tablespaces are applicable only to aggregate storage (ASO) cubes.

The minimum permission required to run this statement is Application Manager.

This statement requires the application to be started.

Syntax

Example

set column_width 50; /* so file_location will not be truncated */
display tablespace ASOSamp.'default';

Table 3-9 Display Tablespace MaxL Output Columns

Column Header	Contents
file_location	`/scratch/oraclehome/applications/essbase/app`
max_file_size	134217727
max_disk_size	4294967295