1. You can see frequent error 1105 for <SID> database as below,
Error: 1105, Severity: 17, State: 4
Can't allocate space for object '<object_name>' in database '<SID>' because 'default' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment.
2. From DBACOCKPIT -> Space -> Tables and Indexes -> Tables, you can see the most largest tables in the <SID> database are SXMSCLUP or SXMSCLUR or both, and they grow fast, maybe >10G per day.
- SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
- SAP NetWeaver (NW) - All versions
- SAP PI System
SXMSCLUP, SXMSCLUR, 1105, grow fast, archiving, deleting, LOGGING, LOGGING_SYNC , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.