10g & 11g Tuning features 10G features: ASSM- Automatic segment space management. It’s a query tuning based feature. We can do a rebuild online. Sql> alter table emp enable row movement; Sql> alter table emp shrink space; We can de-fragment the table by using above two methods. Internally, it will move the data block by block and there will be slowness. Sql> alter table emp shrink space compact; – Compact only work, when the table is not used by anyone. Sql> alter table emp shrink space cascade; – It will shrink both table and indexes. We can use advisory to use the better option. Sql> select * from dba_advisor_logs;…