My focus on Analytics is around installing and use on large projects – i.e big databases, lots of users, and sub 2 second response times.
Obviously you can choose to use Oracle Analytics Cloud, there are certainly some good arguments for doing that, especially when it come to the latest updates. Analytics is at best 3 months behind OAC, and can be up to 15 months behind. But if you are using Analytics Server instead (and there are lots of reasons why you should!), then the series of blogs below will help that to ensure that was a good decision.
With Analytics Server you get a chance to be better than OAC in performance, but only if you follow the advice – it won’t be faster than the significant Oracle Cloud resources without some effort on your part.
Over this year I am drafting several articles to help you get the performance you need, the list below are the planned and published blogs….
My Setup – (in draft) A good test rig is essential to
Introduction to Performance – Starting out with Oracle Analytics Performance.
Design for Performance – Architectural decisions that impact performance
Database Tuning Basics – Focusing on Oracle, explore the basic performance steps
- Parameters, including memory area
- Objects. Tables, Mviews, tablespaces, Indexes
- Database Maintenance
Installation Options – Analytics installation steps that contribute to better performance. also see OAS OS Tuning.
Test and Tune, sleep, Repeat. An overview of the process, and tools we will need for improving performance
Setup Usage Tracking – The built-in Analytics Usage Analysis tool, and how to set it up
BI Server Performance Testing – Using nqcmd to run tests
Web Testing Tools – A look at Load Runner and other tools to simultate
Tuning Weblogic – How to speed up those weblogic bottlenecks
HTTP Server Tuning – Its not just about the the database and weblogic applicatiotn servers!
Analytics Tuning
For the analytics servers we will look at the performance
- BI Server
- Presentation Server
- Weblogic
- Java