Wednesday 11 July 2012

Oracle Table/Index online compression for SAP system


Find out big tables in SAP system, you can compress table and index using following method.
BRTOOLS should be 7.20 (example for BI system table “/BIC/AAS0SDO15500”)


You can see compression enabled or not for Table





  
You can check the size again for table








Hit command 







Choose  option (More you can find out SAP Note 1464156)
I am doing online
ctabind  - compress tables and indexes


















Time taken online 10minutes









Size after compression 







Table status for compression enable