A Wetpaint Site

olapdba

Profile
Friends
Compliments (2)
Contributions (546)

Page Contributions (540)
| Thread Contributions

This report displays all page contributions made by olapdba.

1 2 3 4 5 | Next > Last

	Page	Date/Time	Type	Scope
	Determine OLAP Cube Dimensions Information (11.1.0)	Oct 26 2009, 10:55 AM EDT	edit	9 words added 18 words deleted
Change: owner for a15colaw_nm aw_name for a12 hea AWcol dimension_name for a12 hea DIMENSION col dimensions_type for a6 hea TYPE bre on owner on aw_name skip 1select owner,owner\|\|'.'\|\|aw_name aw_name,aw_nm, dimension_name , decode(dimension_type,'STANDARD','STD',dimension_type) dimensions_type , default_hierarchy_name from all_cube_dimensions order by 1,2,3;OWNER ......... AW ......... DIMENSION View changes from previous version. (Word count: 81) View all updates.
	Determine Dimensional Hierarchy Levels Information (11.1.0)	Oct 26 2009, 10:53 AM EDT	edit	4 words added 2 words deleted
Change: dmn,dmn, hierarchy_name,hierarchy_name, '('\|\|order_num\|\|') '\|\|level_name level_name from all_cube_hier_levels order by 1,2,order_num;DIMENSION .... HIERARCHY ....... LEVEL-------------- ----------------- ---------------------DM.CHANNEL.... SALES_CHANNEL.... (0) TOTAL_CHANNEL................................ (1) CLASS................................ (2) CHANNELDM.CUSTOMER... REGIONAL ........ (0) TOTAL_CUSTOMER................................ (1) CONTINENT................................ (2) COUNTRY................................ (3) STATE_PROVINCE................................ View changes from previous version. (Word count: 118) View all updates.
	Determine Dimensional Hierarchy Levels Information (11.1.0)	Oct 26 2009, 10:53 AM EDT	edit	32 words added 32 words deleted
Change: .............. HIERARCHY ................. LEVEL---------------------------------- ------------------------------------- ----------------------------------------------DM.CHANNEL ............. SALES_CHANNEL .......... (0) TOTAL_CHANNEL......................................................................... (1) CLASS......................................................................... (2) CHANNELDM.CUSTOMER ........... REGIONAL ................... (0) TOTAL_CUSTOMER......................................................................... (1) CONTINENT......................................................................... (2) COUNTRY......................................................................... (3) STATE_PROVINCE......................................................................... View changes from previous version. (Word count: 118) View all updates.
	Determine Existence and ReWriteability of Cube Organized Materialized Views (11.1.0)	Oct 26 2009, 10:50 AM EDT	edit	10 words added 10 words deleted
Change: ................................................................................Build... Refresh..Refresh..RefreshCube Materialized View....................ReWrite Mode.....Mode.... Method...Last Date Staleness-------------------------------------------------------------- ------- -------- --------.-------- --------- ----------------------------DM.CB$CHANNEL_SALES_CHANNEL........ N...... DEFERRED.DEMAND...COMPLETE 29-OCT-07 FRESH.............. DM.CB$CUSTOMER_REGIONAL................ N View changes from previous version. (Word count: 163) View all updates.
	Gather Statistics on Dependent SYS Tables for OLAP Cubes	Oct 22 2009, 3:56 PM EDT	edit	2 words added 2 words deleted
Change: This could be useful in environment where you have dozens to hundreds of hugescubes being updated aat random points in the day.create or replace PROCEDURE gather_olap_stats ISBEGIN dbms_stats.gather_table_stats('sys','aw_prop$',cascade=>true); dbms_stats.gather_table_stats('sys','aw$',cascade=>true); dbms_stats.gather_table_stats('sys','aw_obj$',cascade=>true); dbms_stats.gather_table_stats('sys','ps$',cascade=>true); END;/ View changes from previous version. (Word count: 89) View all updates.
	OLAP option - DBA Sample Scripts	Oct 22 2009, 3:46 PM EDT	edit
Change: There were only format changes (bold, italics, etc.) in this version. See this version for details. (Word count: 442) View all updates.
	Gather Statistics on Dependent SYS Tables for OLAP Cubes	Oct 22 2009, 3:45 PM EDT	edit	70 words added
Change: Updating the statistics on these tables for the optimizer may have major benefits in some cases. The cost of the update is trivial (a couple View changes from previous version. (Word count: 89) View all updates.
	Gather Statistics on Dependent SYS Tables for OLAP Cubes	Oct 22 2009, 3:40 PM EDT	create	No content added or deleted.
Change: Created by olapdba Oct 22 2009, 3:40 PM EDT for: no reason given View all updates.
	OLAP option - DBA Sample Scripts	Oct 22 2009, 3:40 PM EDT	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) View all updates.
	OLAP option - Did You Know?	Jul 23 2009, 1:20 PM EDT	edit	10 words added 4 words deleted
Change: an incarnation of a dropped Multidimensional Datatype from the Recycle Bin. You can use Datapump (IMPDP/EXPDP) to backup and recover Multidimensional Datatypes. You can also do this through OLAP DML and traditional imp/exp. You can use RESUMABLE_TIMEOUT to pause a build if you View changes from previous version. (Word count: 225) View all updates.
	11.Statistics Collection for Oracle OLAP Sessions attached to Multidimensional Datatypes (11.1.0)	Jul 20 2009, 4:21 PM EDT	edit	1 word added 1 word deleted
Change: "SYS"."OLAP_SESSION_STATS""OLAP_SESSION_STATS"( "TIMESTAMP" TIMESTAMP (6) WITH TIME ZONE NOT NULL ENABLE,"USERNAME" VARCHAR2(30) NOT NULL ENABLE,"SID" NUMBER NOT NULL ENABLE,"SERIAL#" NUMBER NOT NULL ENABLE,"INST_ID" NUMBER NOT NULL ENABLE,"OWNER" VARCHAR2(30) NOT NULL ENABLE,"AW_NAME" VARCHAR2(30) NOT NULL ENABLE,"SERVER" VARCHAR2(9) NOT NULL ENABLE,"UGA_USED_MEM" NUMBER,"UGA_MAX_MEM" View changes from previous version. (Word count: 1097) View all updates.
	11.Statistics Collection for Oracle OLAP Sessions attached to Multidimensional Datatypes (11.1.0)	Jul 20 2009, 4:20 PM EDT	edit	43 words added 3 words deleted
Change: .........................................................OLAP ..OLAP PGA MB PGA MB PRC MB PRC MBUSER (SID,SER#,SVR) . ID COLLECTED ....... OLAP AW(GEN)(MODE) ........MB HIT .HIT % . USED .. MAX . USED .ALLOC-------------------- --- ----------------- ---------------------- ------ ------ ------ ------ ------ ------SYS (170,5,D)..........1 View changes from previous version. (Word count: 1098) View all updates.
	11.Statistics Collection for Oracle OLAP Sessions attached to Multidimensional Datatypes (11.1.0)	Jul 20 2009, 4:09 PM EDT	edit	927 words added
Change: These steps should be performed by a privileged user such as SYS or SYSTEMDrop Table and Scheduler Job if existsdrop table olap_session_stats cascade constraints purge;exec sys.dbms_scheduler.drop_job(job_name => '"OLAP_SESSION_STATS_JOB"');Create a New Collections Table with Virtual Columns and Comments CREATE TABLE "SYS"."OLAP_SESSION_STATS" ( "TIMESTAMP" TIMESTAMP View changes from previous version. (Word count: 1098) View all updates.
	OLAP option - DBA Sample Scripts	Jul 20 2009, 3:54 PM EDT	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) View all updates.
	11.Statistics Collection for Oracle OLAP Sessions attached to Multidimensional Datatypes (11.1.0)	Jul 20 2009, 3:52 PM EDT	create	No content added or deleted.
Change: Created by olapdba Jul 20 2009, 3:52 PM EDT for: no reason given View all updates.
	OLAP option - DBA Sample Scripts	Jul 20 2009, 3:51 PM EDT	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) View all updates.
	Discover DBA Scheduler Running Jobs (for Analytic Workspace Manager)	Jul 9 2009, 1:55 PM EDT	edit	26 words added 21 words deleted
Change: select slave_process_idselect, slave_process_id,session_id, session_id,owner, owner,job_name, job_name,instance_name\|\|'('\|\|instance_number\|\|')' instance_nameinstnnfrom dba_scheduler_running_jobs, v$instancegv$instance where running_instance=instance_number;PID ..SID ....Owner ..........Job Name ............InstanceInstance(#)----- ------- --------------- -------------------- ----------------------18 .. 120 ....SCOTT ..........AWXML$_281 ..........orclorcl(1) View changes from previous version. (Word count: 164) View all updates.
	Statistics Collection for Oracle OLAP Sessions attached to Multidimensional Datatypes	Jul 9 2009, 1:44 PM EDT	edit
Change: There were only format changes (bold, italics, etc.) in this version. See this version for details. (Word count: 601) View all updates.
	Statistics Collection for Oracle OLAP Sessions attached to Multidimensional Datatypes	Jul 9 2009, 1:42 PM EDT	edit	121 words added 83 words deleted
Change: gva.session_id = gvs.sid and gvp.inst_id = gvs.inst_id and gvs.inst_id = gva.inst_id and va.session_id=vo.session_idgva.inst_id = gvm.inst_id and vp.addr=vs.paddr gvm.inst_id = gvt.inst_id andvt.statistic#=3 gva.session_id = gvo.session_id and da.aw_number=vo.aw_number gvp.addr = gvs.paddr and gvt.statistic# = vm.pid=vp.pid3 and vp.serial#=vm.serial# da.aw_number = gvo.aw_number and vt.sid=vs.sid gvm.pid = gvp.pid and notgvp.serial# View changes from previous version. (Word count: 601) View all updates.
	Determine Who is Accessing OLAP option Multidimensional Datatypes	Jul 9 2009, 1:33 PM EDT	edit	68 words added 28 words deleted
Change: from dba_aws daws,v$aw_olapwhere vawo,daws.aw_number v$aw_calc= vawc,gvawo.aw_number v$sessionand where sid = daws.aw_number=vawo.aw_numbergvawo.session_id and sid=vawo.session_idgvawc.session_id = sid and vawc.session_idgvawo.inst_id = sidgvawc.inst_id and gvses.inst_id = gvawc.inst_idorder by username, sid, daws.aw_name;USER (SID,SERIAL#,SVR). .. INST_ID OLAP AW (ATTACHED) ... Genrtn----------------------- ---------- View changes from previous version. (Word count: 191) View all updates.

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