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 |
List the Optional Flexible Architecture (OFA) of Oracle database ?
THE MAIN CONCEPT OF PROGRAMMIN TYPE?
What is an Integrity Constrains in Oracle?
When does LGWR write to the database?
How will you estimate the space required by a non-clustered tables?
What is an oracle database schema?
How to implement the multiple control files for an existing database ?
What does LGWR do?
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?
How to find the current session sid
What is an Oracle Data Dictionary?
What is the maximum size of a row in oracle 9i?
4 Answers Baidu, HCL, Yashu Systems,