Solution : https://service.sap.com/sap/support/notes/1171650 (SAP Service marketplace login required)
Summary :
This SAP Note provides guidance on auto-checking Oracle DB parameters against current best practices as detailed in the relevant parameter notes influenced by Oracle release, patch set, and system type. The solution includes SQL statements to run checks for Oracle Releases 8.1, 9.2, 10.1, 10.2, and 11.2, differentiated by system type (OLAP vs OLTP). Detailed instructions for execution via SQL Editor in ST04N, DBA Cockpit, or SQLPLUS are provided, including settings to optimize output. Users are advised to replace certain strings in the queries for OLAP systems as necessary. It also addresses potential execution issues in older SQL editor versions and provides troubleshooting advice for 'too long statement' errors and unlicensed Oracle Diagnostics Package.
Key words :
format a40column set format a8column remark format a60column recommendation format a120column is_value format a50column should_be_value format a50, advanceset linesize 360set pagesize 1000column, minimum optimizer merge fix level, recommended format'<fix 1>, format'<fix 1>, alter system set event='<, note/version 1431798/33optimizer merge fix, bw-based sem-bcs, automatically check patch-dependent parameters, report rsoradjv sqlplusto ensure
Related Notes :
| 1641320 | NLS* parameters are marked as 'MODIFIED' in V$PARAMETER |
| 1342593 | Account search: Performance issue with name and address |
| 830576 | Parameter recommendations for Oracle 10g |
| 212986 | Required data for processing CBO/RBO problems |