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|
Name the ORACLE Background Process?
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 use of Rollback Segments In Database ?
1.Explain the three levels with the help og a diagram.
How will you create multiple rollback segments in a database ?
Teradata: How can we know the indexed column in a table?
List the factors that can affect the accuracy of the estimations ?
what is ORACLE MEMORY STRUCTURES
What is the function of Dispatcher (Dnnn)?
How can we plan storage for very large tables ?
THE MAIN CONCEPT OF PROGRAMMIN TYPE?
How will you swap objects into a different table space for an existing database?