Six Easy Pieces: Database Tuning for Packaged Applications
Packaged applications such as E-Business Suite and Demantra may require significant hardware and performance tuning resources. Large investments in hardware will benefit from period tuning of the application and underlying database. Tuning the database for these packaged applications is quite similar; however, the hardware resources required may be vastly different. We are faced with the constraint that we can’t tune the SQL in these packaged applications, but we can create/drop indexes and gather statistics that generate the best execution plans. In addition to these generally used techniques, there are six more tuning techniques. Use these six techniques to help improve the performance of your packaged application: more hardware resources, partitioning, parallel query, materialized views, maintenance, and proper initialization parameters.
When asked to "Select a payment method" for your free download, choose "Print and Call". Your download code will be e-mailed to you after we authorize it. International customers should enter TruTek's address as the shipping address and enter their real shipping address in the Special Instructions field on the payment screen.
- Item #: Paper0057
