Real Time Training - Week-2(Day 6 - 10)

Day - 8(Exercise)
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 ?
Recent Videos | Today

Fragmentationm

Description about Fragmentationm

Oracle Installation

Description about Installation