What is an Oracle Rollback Segment?
1.Explain the three levels with the help og a diagram.
List the factors that can affect the accuracy of the estimations ?
How will you monitor the space allocation ?
What is Shared Pool?
What is meant by Redo Log file mirrorring ? How it can be achieved?
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?
What is Database Buffers ?
What is an Oracle Data Segment?
What is the role of PCTFREE parameter is Storage clause ?
How to implement the multiple control files for an existing database ?
How does Space allocation table place within a block ?
How can you find the size of a database?