Statistics Collection for Oracle OLAP Sessions attached to Multidimensional Datatypes - History Page

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.

	Date/Time	Made By	Type	Scope
	Jul 9 2009, 1:44 PM EDT	olapdba	edit
Change: There were only format changes (bold, italics, etc.) in this version. See this version for details. (Word count: 601)
	Jul 9 2009, 1:42 PM EDT	olapdba	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)
	Mar 3 2008, 5:34 PM EST	olapdba	edit
Change: There were only format changes (bold, italics, etc.) in this version. See this version for details. (Word count: 594)
	Mar 3 2008, 5:34 PM EST	olapdba	edit
Change: There were only format changes (bold, italics, etc.) in this version. See this version for details. (Word count: 594)
	Mar 3 2008, 5:32 PM EST	olapdba	edit
Change: There were only format changes (bold, italics, etc.) in this version. See this version for details. (Word count: 594)
	Mar 3 2008, 5:32 PM EST	olapdba	edit
Change: There were only format changes (bold, italics, etc.) in this version. See this version for details. (Word count: 594)
	Mar 3 2008, 5:32 PM EST	olapdba	edit
Change: There were only format changes (bold, italics, etc.) in this version. See this version for details. (Word count: 594)
	Jan 24 2008, 11:51 AM EST	olapdba	edit
Change: There were only format changes (bold, italics, etc.) in this version. See this version for details. (Word count: 594)
	Jan 24 2008, 11:51 AM EST	olapdba	edit	44 words added
Change: .................... ................. .............. ...OLAP ..OLAP .PGA MB .PGA MB PROC MB PROC MB .CURS USER (SID,SER#,SVR) . COLLECTED ....... AW(GEN)(MODE) . .....MB .HIT % ...USED ....MAX ...USED ..ALLOC .CURR -------------------- ----------------- -------------- ------- ------ View changes from previous version. (Word count: 594)
	Jan 24 2008, 11:43 AM EST	olapdba	edit	455 words added
Change: These steps should be performed by a privileged user such as SYS or SYSTEMDrop Table and Scheduler Job if exists drop table olap_session_stats cascade constraints purge; exec sys.dbms_scheduler.drop_job(job_name => '"OLAP_SESSION_STATS_JOB"');Create a new collections table create table "OLAP_SESSION_STATS" ( "TIMESTAMP" timestamp (6) with time zone, "USERNAME" varchar2(30), "SID" number, View changes from previous version. (Word count: 594)
	Jan 24 2008, 11:40 AM EST	olapdba	create	No content added or deleted.
Change: Created by olapdba Jan 24 2008, 11:40 AM EST for: no reason given

Home