Answer / siva.k
A Shared SQL area is required to process every unique SQL
statement submitted to a database and contains information
such as the parse tree and execution plan for the
|Is This Answer Correct ?||6 Yes||0 No|
what is the role of archiever
How will you monitor the space allocation ?
What is use of Rollback Segments In Database ?
What are functions of PMON?
What is hit ratio ?
How will you force database to use particular rollback segment?
What is Cursor?
What is the maximum size of a oracle9i database?
What is the maximum number of Lock Processes used?
What does LGWR do?
What is SGA?
How will you estimate the space required by a non-clustered tables?