1. At times JAVA is the culprit for a degraded performance of worksheets
2. End users machine specific setups can help improve performance as well
3. Database maintenance plays key role too
4. Application server settings based on number of concurrent users comes handy too.
The session covered various issues and resolutions for them, it was nicely presented by dividing in short term and long term solutions.
Short term solutions which were discussed in today's session focused on:
- Ensuring End user machines meet minimal system requirements
- Setting up the heap size (Xmx) to maximum possible
- Guidelines to end users for minimizing other applications run during Demantra usage
- Worksheets shall be reviewed and usage of filters is highly recommended
- Setting up params related to Application Server (like MaxUpdateThreads, etc.)
- Running Rebuild_Schema procs to ensure no chain rows exist
- Running Drop_temp to ensure temporary tables aren't eating up space
In long term strategy, few key suggestions were:
- Ensuring strong network connection for end users
- Providing separate tablespace for key tables and their indexes (e.g. sales_data, mdp_matrix etc.)
For complete session coverage and details of all the solutions, you can go to Oracle Community - Demantra Solutions. (or refer to metalink note 800030.1)
1 comment:
Thanks for sharing the info.
Post a Comment