Solution : https://service.sap.com/sap/support/notes/554031 (SAP Service marketplace login required)
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 |