My Oracle Support Banner

How to check Demantra Performance DataBase and Worksheet Parameters (Doc ID 1356886.1)

Last updated on DECEMBER 10, 2024

Applies to:

Oracle Demantra Demand Management - Version 7.3.0.1 and later
Information in this document applies to any platform.

Goal

Troubleshooting by reading Best Practices Notes and frequent specific settings.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
 AWR REPORT
 HARDWARE
 DATABASE PARAMETERS
 MAINTENANCE
 MAINTENANCE JOBS:
 REORDER
 REBUILD TABLES, REORDERING
 Chaining & Fragmentation SQLs:
 CHAINING
 FRAGMENTATION
 Worksheet Performance
 DB Hints
 Loading Data
 Setup Examples:
 PARALLELISM - DBHINT parameters
 1. DB Params2
 2.Worksheet Hints
 3. Query Servlet Report:
 LEVELS - HIERARCHY TREE
 Worksheet Caching
 JAVA Cache
 JAVA HEAP
 ENGINE TUNING
 CASES:
 EP_LOAD Performance Patch 12 2 1
 OTHER CASES:
 INCREASE DS POOL:
  REVIEW PROCEDURES BY DEV
 DATAPUMP IMPORT/EXPORT Performance
 CLIENT SIDE THREAD DUMP
 
<Internal_Only>
 'ImportDataJavaUpdateSetBase' & 'ImportDataJavaUpdate'.
 </Internal_Only>
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.