Chapter 8. Keeping It Running

This chapter is intended for database administrators, or anyone implementing or maintaining Oracle OLAP analytic workspaces or Essbase databases. It covers techniques for keeping your OLAP solution running smoothly.

Many factors can affect the performance of your OLAP cubes. By reviewing the advice in this chapter before implementing Oracle OLAP or Essbase, you may be able to design your implementation to minimize performance issues. If you are inheriting an OLAP system that is underperforming, you should find some hints to guide your optimization efforts. However, do note that sometimes performance problems are not related to OLAP, but rather to metadata, source data, or the network. Such problems can result in poor application performance, even when the cubes are performing well.