Component : Oracle -

Solution : https://service.sap.com/sap/support/notes/78595 (SAP Service marketplace login required)

Summary :
The SAP Note describes sporadic ORA-1575 errors and provides solutions. ORA-1575, indicative of a timeout while waiting for an ST enqueue during space management operations, often results from heavy demand scenarios or large database fragmentation. The SMON process generates these errors particularly during database clean-up activities. Solutions include reorganizing large, fragmented databases, modifying the default storage clause of tablespaces like PSAPTEMP, and disabling automatic space reorganisation using specific event parameters in the init.ora to address persistence of the issue. Manual coalescing of tablespaces is also an option.

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