You can view index file (.ind) and data file (.pag) names, counts, sizes, and totals, and you can determine whether a file is open in Essbase. You may need this information when sizing Essbase caches. You can also see where these files are stored and see whether they span multiple volumes.
Note: | These types of files do not apply to aggregate storage databases. |
To check index (.ind) and data file (.pag) sizes for a database:
From Enterprise View or a custom view, select a database.
Right-click and select Edit, and then Properties.
In Database Properties, select Storage.
For files listed in the Data/Index File Type column, check the file size.
“Allocating Storage and Compressing Data” in the Oracle Essbase Database Administrator's Guide
listfiles (ESSCMD) in the Oracle Essbase Technical Reference
getperfstats (ESSCMD) in the Oracle Essbase Technical Reference