Solution : https://service.sap.com/sap/support/notes/114471 (SAP Service marketplace login required)
Key words :
transaction st04/detailed analysis/sql cache/explain plan, ~ftp/general/3rdparty/oracle/generic/8, located>svrmgrlsvrmgr> connect internalsvrmgr>@us_ind_col, symptom extremely long runtimes, additional key words rsxploracborule, accessing transaction st04, displaying index columns, oracle installation cd 8, dictionary view user_ind_columns, executing script us_ind_col
Related Notes :
| 496165 | ORA-00980/ORA-00942 on USER_IND_COLUMNS |