olapdba

Profile
Friends
Compliments (2)
Contributions (511)

Page Contributions (505)
| Thread Contributions

This report displays all page contributions made by olapdba.

1 2 3 4 5 | Next > Last

	Page	Date/Time	Type	Scope
	Oracle OLAP Versions	Jul 10 2008, 12:38 PM EDT	edit
Change:There were only format changes (bold, italics, etc.) in this version. See this version for details. (Word count: 4727) View all updates.
	Oracle OLAP Versions	Jul 10 2008, 12:37 PM EDT	edit
Change:There were only format changes (bold, italics, etc.) in this version. See this version for details. (Word count: 4727) View all updates.
	Oracle OLAP Versions	Jul 10 2008, 12:36 PM EDT	edit
Change:There were only format changes (bold, italics, etc.) in this version. See this version for details. (Word count: 4727) View all updates.
	Oracle OLAP Option Background	Jul 10 2008, 12:34 PM EDT	edit	7 words added
Change:2007 – Oracle Database 11g was released 2007 – 11.1 – OLAP option integrated with query rewrite engine to expose cubes as materialised views.From the above timeline it is clear that the technology behind the OLAP View changes from previous version. (Word count: 737) View all updates.
	Oracle OLAP Option Background	Jul 10 2008, 12:33 PM EDT	edit	231 words added 9 words deleted
Change: 1977 – Software Development Laboratories (SDL) is the predecessor of Oracle was founded by Larry Ellison, Bob Miner and Ed Oates. (src) 1978 – Oracle Version 1 (never officially released) (src) 1979 – Oracle Version 2 (RDBMS) was released, SDL becomes Relational View changes from previous version. (Word count: 731) View all updates.
	Analyzing Olap Objects Scripts	Jun 16 2008, 10:10 AM EDT	edit	4 words added 2 words deleted
Change:Oracel Database 11g there are new several new OlapOLAP objects. The two that are queryable through the CUBE_TABLE function are CUBES and CUBE_DIMENSIONS. To ensure optimal explain plans View changes from previous version. (Word count: 115) View all updates.
	OLAP option - DBA Sample Scripts	May 29 2008, 10:34 AM EDT	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) View all updates.
	OLAP option - DBA Sample Scripts	May 29 2008, 10:33 AM EDT	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) View all updates.
	Oracle OLAP Option	May 13 2008, 11:22 AM EDT	edit	10 words added 19 words deleted
Change:Software links to software and& documentationDocumentation Documentation - Links to all the documentationOfficial setsDocumentation for 11g, 10g, 9i and& Express Server Oracle OLAP Newsletter - Links to theCurrent currentOLAP newsletterNewsletter and archivearchives Oracle OLAP Blog Feed Oracle OLAP OTN Forum Feed View changes from previous version. (Word count: 191) View all updates.
	My Profile	May 13 2008, 11:08 AM EDT	edit	59 words added 77 words deleted
Change:There were content changes to your 'My Profile' page. View all updates.
	Oracle OLAP Option	May 12 2008, 11:47 AM EDT	edit	1 word added 1 word deleted
Change: GRID Getting Started with Oracle OLAP - Quick links to software and documentation Documentation : - Links to all the documentation sets for 11g, 10g, 9i and Express Server Oracle OLAP Newsletter - Links to the current newsletter and archive Oracle OLAP Blog Feed Oracle OLAP OTN Forum Feed View changes from previous version. (Word count: 202) View all updates.
	Determine Object Dependencies	Apr 28 2008, 11:36 AM EDT	edit
Change:There were only format changes (bold, italics, etc.) in this version. See this version for details. (Word count: 332) View all updates.
	Determine Object Dependencies	Apr 28 2008, 11:34 AM EDT	edit	20 words added 19 words deleted
Change:'CUBE.DIMENSION','CUBE.DIM''CUBE.DIMENSION','CUBE.DIM', type)\|\|')' objdep, referenced_name\|\|' ('\|\|decode(referenced_type, 'EVALUATION CONTXT', 'EVALCTXT', 'NON-EXISTENT CONTXT','NO-EXIST', 'PACKAGE BODY','PKGBDY', 'CUBE.DIMENSION','CUBE.DIM', referenced_type)\|\|')' refrfrom dba_dependencies where owner=:usn order by objdep; Object Name (Type).......................Object Reference (Type)---------------------------------------- -----------------------------------DM.CB$CHANNEL_SALES_CHANNEL (MV) ..............CHANNELS (TABLE).........................................CB$CHANNEL_SALES_CHANNEL (TABLE)DM.CB$CUSTOMER_REGIONAL (MV) ......................CUSTOMERS (TABLE).........................................COUNTRIES (TABLE) View changes from previous version. (Word count: 332) View all updates.
	Determine Object Dependencies	Apr 28 2008, 11:32 AM EDT	edit	15 words added 11 words deleted
Change:.. ............TIMES (TABLE).........................................CB$TIME_CALENDAR (TABLE)DM.CB$TIME_FISCAL (MVIEW)(MV) ................TIMES (TABLE).........................................CB$TIME_FISCAL (TABLE)DM.CHANNEL (CUBE.DIM) ................. ...........AW$DM (TABLE)DM.CHANNELS_DIM (DIM)....................CHANNELS (TABLE)DM.CHANNEL_SALES_CHANNEL_VIEW (VIEW).....CUBE_TABLE (SYNONYM).........................................OLAPIMPL_T (TYPE.BODY).........................................CHANNEL (CUBE.DIMENSION)DM.CHANNEL_VIEW (VIEW)...................CHANNEL (CUBE.DIMENSION).........................................CUBE_TABLE (SYNONYM).........................................OLAPIMPL_T (TYPE.BODY) View changes from previous version. (Word count: 328) View all updates.
	Determine Object Dependencies	Apr 28 2008, 11:30 AM EDT	edit	4 words added 3 words deleted
Change:'CUBE.DIMENSION','CUBE.DIM' type)\|\|')' objdep, referenced_name\|\|' ('\|\|decode(referenced_type, 'EVALUATION CONTXT', 'EVALCTXT', 'NON-EXISTENT CONTXT','NO-EXIST', 'PACKAGE BODY','PKGBDY', referenced_type)\|\|')' refrfrom dba_dependencies where owner=:usn order by objdep; Object Name (Type).......................Object Reference (Type)---------------------------------------- -----------------------------------DM.CB$CHANNEL_SALES_CHANNEL (MVIEW)......CHANNELS (TABLE).........................................CB$CHANNEL_SALES_CHANNEL (TABLE)DM.CB$CUSTOMER_REGIONAL (MVIEW)..........CUSTOMERS (TABLE).........................................COUNTRIES (TABLE).........................................CB$CUSTOMER_REGIONAL (TABLE)DM.CB$PRODUCT_STANDARD View changes from previous version. (Word count: 328) View all updates.
	Determine Object Dependencies	Apr 28 2008, 11:28 AM EDT	edit
Change:There were only format changes (bold, italics, etc.) in this version. See this version for details. (Word count: 324) View all updates.
	Determine Object Dependencies	Apr 28 2008, 11:28 AM EDT	edit	8 words added 1 word deleted
Change:exec :usn := 'DM';break on objdepselect owner\|\|'.'\|\|name\|\|' ('\|\|decode(type, 'MATERIALIZED VIEW', 'MVIEW', 'DIMENSION', 'DIM', 'EVALUATION CONTXT', 'EVALCTXT', 'PACKAGE BODY', 'PKGBDY', type)\|\|')' objdep, referenced_name\|\|' ('\|\|decode(referenced_type, 'EVALUATION CONTXT', 'EVALCTXT', 'NON-EXISTENT CONTXT','NO-EXIST', 'PACKAGE BODY','PKGBDY', referenced_type)\|\|')' refrfrom dba_dependencies where owner='DM'owner=:usn order by objdep; Object Name (Type).......................Object Reference (Type)---------------------------------------- View changes from previous version. (Word count: 324) View all updates.
	Determine Roles and System/Table Privileges Granted to Users	Apr 22 2008, 4:42 PM EDT	edit	6 words added
Change:DIMENSIONSH................................ CREATE MATERIALIZED VIEWSH................................ CREATE SEQUENCESH................................ CREATE SESSIONSH................................ CREATE SYNONYMSH................................ CREATE TABLESH................................ CREATE VIEWSH................................ QUERY REWRITESH................................ UNLIMITED TABLESPACESH............................ ROL CWM_USERSH................................ RESOURCESH................................ SELECT_CATALOG_ROLESH_EMPTY_USER................. --- empty user --- View changes from previous version. (Word count: 253) View all updates.
	Determine Roles and System/Table Privileges Granted to Users	Apr 22 2008, 4:41 PM EDT	edit	2 words added 1 word deleted
Change:user ---' pv from dba_users where not username in (select distinct grantee from dba_role_privs) andnot username in (select distinct grantee from dba_sys_privs) and not username in (select distinct grantee from dba_tab_privs) and username like '%&usercheck%'group by usernameorder by grantee, type, pv;GRANTEE........................TYP PRIVILEGE OR ROLE View changes from previous version. (Word count: 250) View all updates.
	Determine Roles and System/Table Privileges Granted to Users	Apr 22 2008, 4:40 PM EDT	edit
Change:There were only format changes (bold, italics, etc.) in this version. See this version for details. (Word count: 250) 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.

Site pages

Top Contributors