Solution : https://service.sap.com/sap/support/notes/1037651 (SAP Service marketplace login required)
Key words :
prerequisites oracle bug #6033480the parsing times, oracle cost based optimizer takes, import additional service packages, latest optimizer merge fix, experience long parsing times, oracle join syntax, spfile / init<sid>, parsing times, parsing optimizer, oracle database
Related Notes :
| 1093485 | Long parsing times on Oracle |
| 981875 | Optimizer merge fix for Oracle 10.2.0.2 |
| 830576 | Parameter recommendations for Oracle 10g |