Symptom
- User temporary database space is occupied by several temp worktables even though there is no user process/task associated with them in ASE server;
- The occupied space can be shown in 'dbcc usedextents' output like following:
Disk piece 0 (3145728 pages), extents used = 123, worktable extents used = 12056, free = 381037
Total used extents = 123
Total worktable used extents = 12056 <===
Read more...
Environment
SAP Adaptive Server Enterprise ASE 15.7 and 16.0
Product
SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0
Keywords
Sybase, ASEServer, SAPASE, dataserver, tempdb space, worktable, cleaned up, CR 817084, CR817084, 817084, CR817439, CR 817439, 817439, CR816851, CR 816851, 816851 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed
About this page
This 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.