SAP Note 787533 - Bad performance/ system lockup due to enqueue waits

Composant : Oracle - BW ORACLE

Solution : https://service.sap.com/sap/support/notes/787533 (Connexion à SAP Service Marketplace requise)

Mots Clés :
deletedmlspace managementcoalesce free spacealter tablespace coalescereorganizationnext extent size reason, st04 -> detailed analysis menu -> oracle sessions match, command sql>  truncate table <tablename> reuse storage, st04 -> detail analysis menu -> oracle sessions, commandsql> alter table <tablename> deallocate unused, sql> alter table <tablename> deallocate unused, st04 --> detailed analysis session -> oracle sessions, sql> alter table <tablename> allocate extent, oracle sessions show enqueue waitsthere, sqlsql> select' alter index

Notes associées :

745639FAQ: Oracle enqueues
618868FAQ: Oracle performance
541538FAQ: Reorganization
214995Oracle locally managed tablespaces in the SAP environment