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 does LGWR do?
When Does DBWR write to the database?
What is an Oracle Data Block?
What is the function of checkpoint(CKPT)?
How can we plan storage for very large tables ?
What is the OPTIMAL parameter ?
When does LGWR write to the database?
What is the maximum size of a oracle9i database?
What is Database Buffers ?
Why query fails sometimes ?
How to implement the multiple control files for an existing database ?
What is an Oracle Data Segment?