Solution : https://service.sap.com/sap/support/notes/212986 (SAP Service marketplace login required)
Key words :
choosetransaction st04 -> detailed analysis -> sql requeststo choose, script $oracle_home/rdbms/admin/utlxplan, automatic oracle database parameter check, alter session set events '10053 trace, $oracle_home/saptrace/usertracethe trace file, directory $oracle_home/saptrace/usertrace, oracle remote diagnostic agent, relevant sql script, abap source code, /explain plan forselect / + 0 /
Related Notes :
| 1257075 | SQL_ID Data Collector (Oracle 10.2.0.2 or higher) |
| 1171650 | Automated Oracle DB parameter check |
| 1005931 | Oracle Remote Diagnostic Agent (RDA) |