What is Shared SQL Area?
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
corresponding statement.
| Is This Answer Correct ? | 6 Yes | 0 No |
What is the maximum number of Lock Processes used?
What is the use of Oracle Control File?
What is the function of ARCH?
What are disadvanteges of having raw devices ?
How does Space allocation table place within a block ?
What is User Process?
What is the OPTIMAL parameter ?
How will you monitor rollback segment status ?
What is Cursor?
When Does DBWR write to the database?
What is an Integrity Constrains in Oracle?
What is PGA?