| 1. Create a job to gather the stat for schema - SCOTT every one hour ? |
| 2. Create a job to find the fragmentation ? |
| 3. Create a table like all_objects on a newly created tablespace (eg. Tbs) ? |
| 4. Alter the table and add an extra column as “aoid” ? |
| 5. Create an index and primary key on column “aoid” ? |
| 6. Create composite index on (owner, object_id) ? |
| 7. Create a sequence to generate values for the column “aoid” ? |
| 8. All other data to be inserted from all_objects(upto 1lak records) ? |
| 9. Check table size, index size ? |
| 10. Check number of extents, number of blocks of tables and indexes ? |
| 11. Delete from table where rownum < 50000; ? |
| 12. Check table size, index size ? |
| 13. Check number of extents, number of blocks of tables and indexes ? |
| 14. The size will remain the same, explain why ? |
| 15. Check the fragmentation for table, index ? |
| 16. De-fragment using move query ? |
| 17. Check the index status ? |
| 18. Check table size, index size ? |
| 19. Check number of extents, number of blocks of tables and indexes ? |
| 20. Insert more records (upto 1 lakh) ? |
| 21. Check table size, index size ? |
| 22. Check number of extents, number of blocks of tables and indexes ? |
| 23. Delete from table where rownum < 50000; ? |
| 24. Check table size , index size ? |
| 25. Check number of extents, number of blocks of tables and indexes ? |
| 26. Check the fragmentation for table, index ? |
| 27. Defragment the table using shrink query ? |
| 28. Insert more records (upto 1 lakh) ? |
| 29. Check table size , index size ? |
| 30. Check number of extents, number of blocks of tables and indexes ? |
| 31. Delete from table where rownum < 50000; ? |
| 32. Check table size , index size ? |
| 33. Check number of extents, number of blocks of tables and indexes ? |
| 34. Check the fragmentation for table, index ? |
| 35. Defragment the table online redefinition ? |
| 36. Change the invalid objects to valid state ? |
