Wednesday, June 3, 2009

Notes from Today's Webcast on "The Key to Optimizing Demantra Worksheet Performance"

Today's webcast was another session full of information on how to ensure that you are getting best performance from Demantra worksheets. Few key points to take away were:

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:

Anonymous said...

Thanks for sharing the info.

Perspectives on Managing through Difficult Times