A Wetpaint Site

OLAP option - DBA Sample Scripts

Page Versions
To-Dos

Key: additions deletions

1 2 3 4 5 | Next > Last

	Date/Time	Made By	Type	Scope
	Oct 22 2009, 3:46 PM EDT	olapdba	edit
Change: There were only format changes (bold, italics, etc.) in this version. See this version for details. (Word count: 442)
	Oct 22 2009, 3:40 PM EDT	olapdba	edit	12 words added
Change: 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 View changes from previous version. (Word count: 442)
	Jul 20 2009, 3:54 PM EDT	olapdba	edit	3 words added 1 word deleted
Change: 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)(Link) View changes from previous version. (Word count: 432)
	Jul 20 2009, 3:51 PM EDT	olapdba	edit	12 words added
Change: 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) View changes from previous version. (Word count: 432)
	Jan 22 2009, 1:11 PM EST	olapdba	edit
Change: There were only format changes (bold, italics, etc.) in this version. See this version for details. (Word count: 418)
	Jan 22 2009, 12:51 PM EST	olapdba	edit	3 words added 1 word deleted
Change: (Link)(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 ( View changes from previous version. (Word count: 418)
	Jan 22 2009, 12:48 PM EST	olapdba	edit	11 words added
Change: 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 View changes from previous version. (Word count: 418)
	May 29 2008, 10:34 AM EDT	olapdba	edit	7 words added 7 words deleted
Change: 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 View changes from previous version. (Word count: 407)
	May 29 2008, 10:33 AM EDT	olapdba	edit	1 word added 1 word deleted
Change: (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) Analyzing OlapOLAP Objects (11.1.0) (Link) View changes from previous version. (Word count: 407)
	May 29 2008, 10:24 AM EDT	Christopher.Kearney	edit	7 words added
Change: 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)Analyzing Olap Objects (11.1.0) (Link) View changes from previous version. (Word count: 407)
	Apr 17 2008, 1:17 PM EDT	olapdba	edit	6 words added
Change: 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 View changes from previous version. (Word count: 400)
	Apr 17 2008, 12:37 PM EDT	olapdba	edit	28 words added 1 word deleted
Change: 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) View changes from previous version. (Word count: 396)
	Apr 17 2008, 12:32 PM EDT	olapdba	edit	8 words added
Change: Free Memory in SGA (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 View changes from previous version. (Word count: 368)
	Apr 17 2008, 12:26 PM EDT	olapdba	edit	15 words added
Change: 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) View changes from previous version. (Word count: 362)
	Apr 17 2008, 12:10 PM EDT	olapdba	edit	4 words added 2 words deleted
Change: scriptsscript samples are intended for advanced database practitioners and consultantsconsultants. 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 View changes from previous version. (Word count: 349)
	Apr 17 2008, 12:09 PM EDT	olapdba	edit	12 words added
Change: Note: Some of these scripts are for advanced database practitioners and consultants 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 View changes from previous version. (Word count: 347)
	Apr 17 2008, 12:08 PM EDT	olapdba	edit	17 words added
Change: 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) View changes from previous version. (Word count: 335)
	Apr 17 2008, 11:57 AM EDT	olapdba	edit	12 words added
Change: 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) View changes from previous version. (Word count: 321)
	Apr 17 2008, 11:49 AM EDT	olapdba	edit
Change: There were only format changes (bold, italics, etc.) in this version. See this version for details. (Word count: 311)
	Apr 17 2008, 11:48 AM EDT	olapdba	edit	12 words added
Change: Amount of PGA occupied by OLAP option Sessions (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 View changes from previous version. (Word count: 311)

1 2 3 4 5 | Next > Last

JavaScript must be enabled in order for you to contribute to this site.
To start contributing, enable JavaScript by changing your browser options, then try again.

Home