Solution : https://service.sap.com/sap/support/notes/896717 (SAP Service marketplace login required)
Summary :
SAP Note explains an issue where tables like VBDATA in ASSM tablespaces grow excessively due to space mismanagement during insert/delete operations. Blocks are marked as 'full' prematurely, causing unneeded growth, particularly in tables with LONG RAW fields. A conditional fix is available in Oracle 9.2.0.8, allowing administrators to choose between preventing table growth or performance reduction during inserts. However, using this fix in mass operations is not recommended. The issue is resolved in Oracle 10.2.0.4, and patches for interim versions are available for download from SAP Service Marketplace.
Key words :
ziphp ux itanium 64-bit /oracle/oracle 64-bit/oracle 9, ziphp tru64 64-bit /oracle/oracle 64-bit/oracle 9, ziplinux ia_64 /oracle/oracle 64-bit/oracle 9, aix 5l /oracle/oracle 64-bit/oracle 9, ziplinux x86-64 /oracle/oracle 64-bit/oracle 9, ziplinux 32-bit /oracle/oracle 64-bit/oracle 9, oracle 64-bit /oracle/oracle 64-bit/oracle 9, 64-bit/ aix_5l_64/p4660718_92080_aix64-5l, 64-bit/ linux_x86_64/p4660718_92080_linux-x86-64, 64-bit/ linux_ia_64/p4660718_92080_linux-ia64
Related Notes :
| 830965 | VBDATA, DDLOG: size and increase in size |
| 821687 | FAQ: Space utilization and fragmentation in Oracle |
| 766349 | FAQ: Oracle SQL optimization |
| 712624 | High CPU consumption by Oracle |