| Other Architecture Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How to find the current session sid | | 2 |
| What is hit ratio ? | | 1 |
| What is the function of checkpoint(CKPT)? | | 1 |
| What is dictionary cache ? | | 2 |
| What is meant by recursive hints ? | | 1 |
| Why query fails sometimes ? | | 1 |
| What does LGWR do? | | 1 |
| What is the function of Lock (LCKn) Process? | | 1 |
| What are functions of PMON? | | 4 |
| What is meant by free extent ? | | 2 |
| When does LGWR write to the database? | | 3 |
| what is the role of archiever | Satyam | 1 |
| what is ORACLE MEMORY STRUCTURES | | 1 |
| When Does DBWR write to the database? | | 4 |
| What is a Multi-threaded Server Configuration? | | 1 |
| What is meant by redo log buffer ? | | 1 |
| What Does DBWR do? | | 2 |
| When will be a segment released? | | 1 |
| How will you force database to use particular rollback
segment? | | 1 |
| What is the maximum number of Lock Processes used? | | 1 |
| |
| For more Architecture Interview Questions Click Here |