SAP Note 896717 - Problems with tables in ASSM tablespaces

Component : Oracle - BW ORACLE

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 :

830965VBDATA, DDLOG: size and increase in size
821687FAQ: Space utilization and fragmentation in Oracle
766349FAQ: Oracle SQL optimization
712624High CPU consumption by Oracle