Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 75 Insurance
- 537.7K On-Premises Infrastructure
- 138.7K Analytics Software
- 38.6K Application Development Software
- 6.1K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.3K Infrastructure Software
- 105.4K Integration
- 41.6K Security Software
Performance issue
sandy45252
Member Posts: 72
Hi all
we have got a fact table which contains 25 million records and when generating the report its taking a lot of time,how to improve its performance and what i need to do at administration side ,webservices side and at database side.
we have got a fact table which contains 25 million records and when generating the report its taking a lot of time,how to improve its performance and what i need to do at administration side ,webservices side and at database side.
Tagged:
Answers
-
read
http://download.oracle.com/docs/cd/E05554_01/books/PDF/AnyTuning.pdf -
Aggregate tables would be a good start. You can use the Aggregate Persistence Wizard in the OBIEE Admin Tool to create them.
-
-Revisit the Requirement and try to group or eliminate data
-Ship most of the functions to the Database.
-Use Aggregates, and design proper Aggregate Navigation
-User BI server Caching mechanism and set up caching strategy.
-Use Presentation Server Cache
-use index, hints on the database columns
This discussion has been closed.