Note: Some of these script samples are intended for advanced database practitioners and consultants while others are generic in nature. Please use at your own risk and post a note if you need additional information or wish to modify/optimize the scripts.
Generic Scipts covering Oracle Database 10g Release 2 and later
- Comprehensive Tablespace Report with Oracle OLAP Multidimensional Datatype Information (Link)
- Determine "On Disk" Size of OLAP option Multidimensional Datatypes (Link)
- Determine All OLAP Catalogue Objects Visible to a Schema (10.2.0) (Link)
- Determine Amount of PGA occupied by OLAP option Sessions (Link)
- Determine OLAP option Multidimensional Datatypes in the Buffer Cache (Link)
- Determine OLAP options Components and Version (Link)
- Determine Object Dependencies (Link)
- Determine Oracle Instance Status (Link)
- Determine Platform Information from SQL*Plus (Link)
- Determine Process/PGA Memory in use by Process (Link)
- Determine Roles and System/Table Privileges Granted to Roles (Link)
- Determine Roles and System/Table Privileges Granted to Users (Link)
- Determine Space OLAP option Schemas are Occupying on a Database (Link)
- Determine SQL Text for Users attached to OLAP Multidimensional Datatypes (Link)
- Determine Tablespace and Datafile I/O Activity (Link)
- Determine Version, Amount of Pagespaces and Generations in OLAP option Multidimensional Datatypes (Link)
- Determine Wait Events for Sessions Attached to OLAP Multidimensional Datatypes (Link)
- Determine Who is Accessing OLAP option Multidimensional Datatypes (Link)
- Discover DBA Scheduler Running Jobs (for Analytic Workspace Manager) (Link)
- Display Tables and Corresponding Information on Indices (Link)
- Free a Session of Allocated OLAP Page Memory (Link)
- Gather Statistics on Dependent SYS Tables for OLAP Cubes (Link)
- Monitor Free Memory in SGA (Link)
- Monitor Index Usage (Link)
- Monitor OLAP option Multidimensional Datatype TEMP & LOB Reads, Cache Writes and Rows Processed (Link)
- Monitor Per Session UGA, PGA and Cursor Usage (Link)
- Performance Snapshot for Sessions Accessing OLAP option Multidimensional Datatypes (Link)
- Simple Space Report with OLAP Multidimensional Datatype Information (Link)
- Statistics Collection for Oracle OLAP Sessions attached to Multidimensional Datatypes (Link)
Scripts Pertaining to Oracle Database 11g
- Analyzing OLAP Objects (11.1.0) (Link)
- Determine Dimensional Hierarchy Levels Information (11.1.0) (Link)
- Determine Existence and ReWriteability of Cube Organized Materialized Views (11.1.0) (Link)
- Determine OLAP Cube Derived Measures Information (11.1.0) (Link)
- Determine OLAP Cube Dimensions Information (11.1.0) (Link)
- Determine OLAP Cube Information (11.1.0) (Link)
- Determine OLAP Cube and Dimension Views (11.1.0) (Link)
- Monitor Session Information for Multidimensional Datatype Access (11.1.0) (Link)
- Verify OLAP option Multidimensional Datatype State (Generations, Pagespaces, etc.) (11.1.0) (Link)
- Verify Physical Properties of OLAP option Multidimensional Datatypes (11.1.0) (Link)
- Statistics Collection for Oracle OLAP Sessions attached to Multidimensional Datatypes (11.1.0) (Link)