|
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 11 g 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_ROLE SH_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.
|