Real Time Training - Week-1(Day 1 - 5)
S.No | Title |
---|---|
1 | Control file |
2 | Log file |
3 | Archive log file |
4 | Exercise (Questions) |
S.No | Title | |
---|---|---|
1 | Dbca Creation | |
2 | Manual db creation | |
3 | Exercise (Questions) |
1. List out 10 memory level parameters ? |
2. Which commands leads to sorting? What memory area is used for sorting ? How will you increase the performance of sorting ? Name the parameters ? |
3. What will happen if you give commit? What are the wait events that affect log buffer ? |
4. What will happen if you give commit? What are the wait events that affect log buffer ? |
5. What will happen if you give commit? What are the wait events that affect log buffer ? |
6. How will you increase the size of library cache? What is hard and soft parse ? |
7. What is checkpoint?How will reduce the checkpoint frequency ? |
8. Explain the steps that involved when bringing up the database? How to drop the database? how to change the mode of database ? |
9. Explain instance recovery? Who does instance recovery ? Where will you check whether the instance recovery happened or not ? What files were involved in the Instance recovery ? |
10. Who read the data into memory ? How will you increase the performance of write from DBBC to datafiles ? |
11. What is difference between ORACLE_BASE and ORACLE_HOME ? |
12. I have a 50 Unix servers, what is fastest method to install oracle ? |
13. Why we need to execute root.sh ? |
14. What is the prerequisite to install Oracle on Linux ? |
15. How will you configure automatic startup and shutdown options ? |
16. How will release memory from OS (or) When i restart the database i get unable to allocate shared memory segment ? |
Next Topic » ( Week - 2 (Day 6 - 10) )
Recent Videos | Today
Fragmentationm
Description about Fragmentationm
Oracle Installation
Description about Installation