Solution : https://service.sap.com/sap/support/notes/601157 (SAP Service marketplace login required)
Key words :
sysdba sql>shutdown sql>startup sql>show parameter spfilethe parameter 'spfile', sysdba sql>shutdown sql>startup sql>show parameter spfile spfile - migration, - setting system parameters temporarily - resetting system parameters - setting events, sql>show parameter spfilean empty string means, sql>alter system reset <parameter_name> scope = spfile sid = ' ', sql>alter system reset event scope=spfile sid=' ', explanationsgeneral recommendationspfile - descriptionspfile - search sequencespfile - functions, constraintsspfile - advantagesspfile - special featuresspfile - special features, sql>alter system set _push_join_predicate=false scope=spfile, longer execute 'alter system set' commands
Related Notes :
| 1178409 | ORA-32021: parameter value longer than 255 characters |
| 948197 | Merge fix for DBMS_STATS package on Oracle 9.2.x and 10.2.x |
| 848708 | Oracle Database Configuration for NWDI server |
| 830576 | Parameter recommendations for Oracle 10g |
| 773173 | Using Oracle Fail Safe cluster on Windows with SPFILE |
| 647697 | BRSPACE - New tool for Oracle database administration |
| 598678 | Oracle 9i: New functions |
| 596423 | Events and SPFILE |