What general checks can be carried out in the event of Oracle performance problems?
Using Note 124361 (for Oracle 9i and older) or Note 830576 (for Oracle 10g and newer) and the notes they refer to, ensure that parameters correspond to recommendations and correct these where necessary. For R/3 3.x, see also Note 160063. For I/O configuration, see Note 793113. The following parameters are particularly relevant to performance: DB_FILE_MULTIBLOCK_READ_COUNT, OPTIMIZER_MODE, OPTIMIZER_INDEX_COST_ADJ, OPTIMIZER_INDEX_CACHING, HASH_JOIN_ENABLED, STAR_TRANSFORMATION_ENABLED, DISK_ASYNCH_IO, EVENT, FILESYSTEMIO_OPTIONS, _B_TREE_BITMAP_PLANS, _PUSH_JOIN_PREDICATE, _OPTIM_PEEK_USER_BINDS, _SORT_ELIMINATION_COST_RATIO. Also check if special parameters are set that were used for a temporary solution or analysis of a previous problem, but are now no longer required. These include underscore and event parameters that do not comply with SAP standard recommendations. Since some of these settings lead to severe performance problems, remove these settings when you no longer need them (
Related Questions
- What general checks can be carried out in the event of Oracle performance problems?
- What general checks can be carried out if there are MaxDB performance problems?
- What general checks can be carried out if there are MaxDB performance problems?
- Can I use this FAQ to solve all MaxDB performance problems?
- Can I hold an event/performance at FraserStudios?
- Can I hold an event/performance at FraserStudios?
