Oracle database checklist
You can review the Oracle database checklist for specific setting recommendations.
| Recommendation | Section | Dev | Prod | Comments |
|---|---|---|---|---|
| Set cursor_sharing=FORCE | Cursor_sharing | C | C | This parameter makes dynamic SQL reusable, which reduces contention on the shared pool. |
| Oracle: Check if histograms are needed | Index and table statistics | NA | C | As you start to populate the database, check to see if there
are indexed columns that have skewed data distribution - for example,
most rows have the same value (e.g., space). These could include fields
like derived_from_order_header_key, chained_from_order_header_key, derived_from_order_line_key,
chained_from_order_line_key. If there are skewed columns, add a histogram. The performance impact is very noticeable. One customer saw a query that took 30 seconds drop to sub-second. |