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|
How to implement the multiple control files for an existing database ?
When will be a segment released?
How many Dispatcher Processes are created?
When Does DBWR write to the database?
How can you find the size of a database?
What is Shared Pool?
What is advantage of having disk shadowing/ Mirroring ?
What is User Process?
THE MAIN CONCEPT OF PROGRAMMIN TYPE?
1.Explain the three levels with the help og a diagram.
What is a Rollback segment entry ?
What is Shared SQL Area?