Location: Oracle OLAP How To

Discussion: Performance Tunniing for database with OLAP option

Keyword tags: AWM calculated measure cube Dimension Hierarchy Level OLAP Oracle OLAP Option

Watch

Anonymous  (Get credit for your thread)
jeegar

jeegar		 Performance Tunniing for database with OLAP option
Feb 7 2008, 12:44 AM EST
Hi
Can Anybody help for how to tune oracle database with OLAP option ?
 5  out of 7 found this valuable. Do you?    
olapdba
olapdba		 RE: Performance Tunniing for database with OLAP option
Feb 8 2008, 10:17 AM EST
There are several things you need to look at

1) Your Business Model
2) Your Cube Design
3) Database Tuning and Sizing

If you are looking at database tuning I would suggest having a look at Oracle OLAP Terminology (http://wiki.oracle.com/page/Oracle+Olap+Terminology), Oracle OLAP Blog (http://oracleolap.blogspot.com), post specific OLAP tuning questions to the OTN Forum (http://forums.oracle.com/forums/forum.jspa?forumID=16) and have a look at the OLAP option - DBA Sample Scripts (http://wiki.oracle.com/page/OLAP+option+-+DBA+Sample+Scripts).

This is a good topic I will add it as a section under "Oracle OLAP How To" 4  out of 6 found this valuable. Do you?    

Related Content

  (what's this?Related ContentThanks to keyword tags, links to related pages and threads are added to the bottom of your pages. Up to 15 links are shown, determined by matching tags and by how recently the content was updated; keeping the most current at the top. Share your feedback on Wetpaint Central.)
What are the steps to implement SCD2 in "rpd" in OBIEE ? Oracle BI, Warehousing & Analytics IOUG SIG User Meeting, Dec. 2-3 OLAP Newsletter
Additional Scripts BIWA Summit 2008 Call for Presentations is open OLAP option - DBA Sample Scripts
Analytic Workspace Manager Oracle OLAP Option The Fall DC2008 Call for Presentations is now open!
DISCOVERER: Quick Tips Getting Started With Oracle OLAP Option OLAP Option Just Give me the Software