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