Solution : https://service.sap.com/sap/support/notes/78595 (SAP Service marketplace login required)
Key words :
sqlplus> alter tablespace psaptemp default storage, parallel loads involving large amounts, sqldba> alter session set events ', sqlplus> alter tablespace psaptemp coalesce, large sort activities - heavy load, alter session set events ', terms smon timeout reason, disable normal space reorganisation, smon background process ifthere, symptom ora-1575 occurs sporadically
Related Notes :
745639 | FAQ: Oracle enqueues |
659946 | FAQ: Temporary tablespaces |
183791 | Locking on temporary tablespace of Oracle |