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 |
How to calculate the approximate size of the SGA based on the size of the block,shared_pool,redo_buffer_cache and db_buffer_cache?
Which parameter in Storage clause will reduce no. of rows per block?
How will you create multiple rollback segments in a database ?
What is an oracle database schema?
How the log writer writes the data into database
What is PGA?
What is an Oracle Data Segment?
What are the uses of Oracle Rollback Segment?
What is hit ratio ?
What is the maximum number of Lock Processes used?
What are the two types of Server Configurations?
What constitute an ORACLE Instance?