| 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 ? |
