Solution : https://service.sap.com/sap/support/notes/507254 (SAP Service marketplace login required)
Key words : 
database type oracleusage type aactive indicator aanalysis method, oracle cost-based optimizer, kocludatabase object type, oracle shared pool, svrmgrlconnect internalselect last_analyzed, pool tables generally, database server, p10customer indicator, prerequisites generally, last_analyzed column
Related Notes : 
       
| 690241 | The Shared SQL Area in the Shared Pool and large SQL Stmnts | 
| 557447 | ORA-4031 After upgrade to Oracle 8.1.x.x | 
| 556764 | Upgrade hangs in phase ACT_<REL> | 
| 521264 | Hang situations | 
| 505246 | Several ora-600 [12333] and ora-4031 errors |