1.Explain the three levels with the help og a diagram.
Answer / nagaraj
3 levels in performance tuning
1. system level
2. network level
3. database level
3 tier architure
1. client side
2. application side
3. database side
| Is This Answer Correct ? | 4 Yes | 5 No |
What is a Control file ?
How free extents are managed in Ver 6.0 and Ver 7.0 ?
What is the maximum number of Lock Processes used?
What is Shared SQL Area?
What is the functionality of SYSTEM table space ?
what is the role of archiever
What are the functions of SMON?
What is advantage of having disk shadowing/ Mirroring ?
What constitute an ORACLE Instance?
What is use of Rollback Segments In Database ?
What is meant by free extent ?
What is User Process?