Version User Scope of changes
Oct 22 2009, 3:46 PM EDT (current) olapdba
Oct 22 2009, 3:40 PM EDT olapdba 12 words added

Changes

Key:  Additions   Deletions
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


  1. Comprehensive Tablespace Report with Oracle OLAP Multidimensional Datatype Information (Link)
  2. Determine "On Disk" Size of OLAP option Multidimensional Datatypes (Link)
  3. Determine All OLAP Catalogue Objects Visible to a Schema (10.2.0) (Link)
  4. Determine Amount of PGA occupied by OLAP option Sessions (Link)
  5. Determine OLAP option Multidimensional Datatypes in the Buffer Cache (Link)
  6. Determine OLAP options Components and Version (Link)
  7. Determine Object Dependencies (Link)
  8. Determine Oracle Instance Status (Link)
  9. Determine Platform Information from SQL*Plus (Link)
  10. Determine Process/PGA Memory in use by Process (Link)
  11. Determine Roles and System/Table Privileges Granted to Roles (Link)
  12. Determine Roles and System/Table Privileges Granted to Users (Link)
  13. Determine Space OLAP option Schemas are Occupying on a Database (Link)
  14. Determine SQL Text for Users attached to OLAP Multidimensional Datatypes (Link)
  15. Determine Tablespace and Datafile I/O Activity (Link)
  16. Determine Version, Amount of Pagespaces and Generations in OLAP option Multidimensional Datatypes (Link)
  17. Determine Wait Events for Sessions Attached to OLAP Multidimensional Datatypes (Link)
  18. Determine Who is Accessing OLAP option Multidimensional Datatypes (Link)
  19. Discover DBA Scheduler Running Jobs (for Analytic Workspace Manager) (Link)
  20. Display Tables and Corresponding Information on Indices (Link)
  21. Free a Session of Allocated OLAP Page Memory (Link)
  22. Gather Statistics on Dependent SYS Tables for OLAP Cubes (Link)
  23. Monitor Free Memory in SGA (Link)
  24. Monitor Index Usage (Link)
  25. Monitor OLAP option Multidimensional Datatype TEMP & LOB Reads, Cache Writes and Rows Processed (Link)
  26. Monitor Per Session UGA, PGA and Cursor Usage (Link)
  27. Performance Snapshot for Sessions Accessing OLAP option Multidimensional Datatypes (Link)
  28. Simple Space Report with OLAP Multidimensional Datatype Information (Link)
  29. Statistics Collection for Oracle OLAP Sessions attached to Multidimensional Datatypes (Link)


Scripts Pertaining to Oracle Database 11g

  1. Analyzing OLAP Objects (11.1.0) (Link)
  2. Determine Dimensional Hierarchy Levels Information (11.1.0) (Link)
  3. Determine Existence and ReWriteability of Cube Organized Materialized Views (11.1.0) (Link)
  4. Determine OLAP Cube Derived Measures Information (11.1.0) (Link)
  5. Determine OLAP Cube Dimensions Information (11.1.0) (Link)
  6. Determine OLAP Cube Information (11.1.0) (Link)
  7. Determine OLAP Cube and Dimension Views (11.1.0) (Link)
  8. Monitor Session Information for Multidimensional Datatype Access (11.1.0) (Link)
  9. Verify OLAP option Multidimensional Datatype State (Generations, Pagespaces, etc.) (11.1.0) (Link)
  10. Verify Physical Properties of OLAP option Multidimensional Datatypes (11.1.0) (Link)
  11. Statistics Collection for Oracle OLAP Sessions attached to Multidimensional Datatypes (11.1.0) (Link)