Real Time Training - Week-2(Day 6 - 10)
Day - 6(Exercise)| 1. Create undo tablespace and assign it as default undo tablespace ? |
| 2. Create new temp tablespace and assign default temp ? |
| 3. Create table snao as select * from all_objects where rownum < 10 ? |
| 4. Check how much extend,blocks,size table as occupied ? |
| 5. Check the value for pct free,pct used and pct increase ? |
| 6. Check value for maxtrans,initrans,initialextend,nextextend,min extend,max extend,status of logging ? |
| 7. Increase the initrans value 32 and pct free to 40% ? |
| 8. Show demo on row migration ? |
| 9. Simulate snapshot too olderror ? |
| 10. Simulate lock and deadlock ? |
| 11. Execte sql which does sorting and find the temp usage ? |
