Solution : https://service.sap.com/sap/support/notes/554031 (SAP Service marketplace login required)
Summary :
The SAP note primarily addresses the management and collection of space statistics in SAP databases, detailing methods involving BRCONNECT commands. It categorizes database statistics into optimizer statistics—essential for the Cost Based Optimizer (CBO) for optimal data access—and space statistics, which help determine table and index space consumption for upgrades or reorganizations. Notably, space statistics enhance optimizer statistics but are not routinely collected unless needed, and their collection can be influenced by the use of DBMS_STATS Oracle package, which may not create all space statistics.
Key words :
occbl+hwmbl indbspure data nrows arowl+hwmbl indruyou, sqlplus /nolog @sap_index_stats81sqlplus /nolog @sap_index_stats92sqlplus /nologsql> connect /, table index ----------------- -------------------allocated space occbl+empbl+hwmbl indblused space, occbl indbspure data nrows arowl indruas, tname - table nameiname - index nameandat - analysis date, table index ----------------- -------------------allocated space occbl+empbl indblspace, database user ops$ora<sid> exists, sql> create synonym ops$<sid>adm, sql> create synonym ops$ora<sid>, tname - table nameandat - analysis date
Related Notes :
| 936441 | Oracle settings for R3load based system copy |
| 821687 | FAQ: Space utilization and fragmentation in Oracle |