Welcome! Wikis are websites that everyone can build together. It's easy!

OLAP option - DBA Sample Scripts

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 Tablespace and Datafile I/O Activity (Link)
  15. Determine Version, Amount of Pagespaces and Generations in OLAP option Multidimensional Datatypes (Link)
  16. Determine Wait Events for Sessions Attached to OLAP Multidimensional Datatypes (Link)
  17. Determine Who is Accessing OLAP option Multidimensional Datatypes (Link)
  18. Discover DBA Scheduler Running Jobs (for Analytic Workspace Manager) (Link)
  19. Display Tables and Corresponding Information on Indices (Link)
  20. Free a Session of Allocated OLAP Page Memory (Link)
  21. Monitor Free Memory in SGA (Link)
  22. Monitor Index Usage (Link)
  23. Monitor OLAP option Multidimensional Datatype TEMP & LOB Reads, Cache Writes and Rows Processed (Link)
  24. Monitor Per Session UGA, PGA and Cursor Usage (Link)
  25. Performance Snapshot for Sessions Accessing OLAP option Multidimensional Datatypes (Link)
  26. Simple Space Report with OLAP Multidimensional Datatype Information (Link)
  27. 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)



Latest page update: made by olapdba , May 29 2008, 10:34 AM EDT (about this update About This Update olapdba Edited by olapdba

7 words added
7 words deleted

view changes

- complete history)
More Info: links to this page

Anonymous  (Get credit for your thread)


Started By Thread Subject Replies Last Post
olapdba Additional Scripts 7 Wednesday, 2:11 AM EDT by say2preetiyadav@yaho
olapdba
Thread started: Jan 9 2008, 1:52 PM EST  Watch
If you are interested in seeing more examples please make your suggestions here in this thread. I will continue adding scripts as time goes on and I have scripts covering 9.2, 10.1 and 10.2 as well if you are interested.
15  out of 22 found this valuable. Do you?    
Show Last Reply

Related Content

(what's this?Related ContentThanks to keyword tags, links to related pages and threads are added to the bottom of your pages. Up to 15 links are shown, determined by matching tags and by how recently the content was updated; keeping the most current at the top. Share your feedback on Wetpaint Central.)
Wiki pages
Top Contributors