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 |
How does Space allocation table place within a block ?
What is the function of Lock (LCKn) Process?
What is the maximum size of a oracle9i database?
What is an Oracle Data Dictionary?
What are the uses of Oracle Rollback Segment?
How to find the SGA Size
What is a Multi-threaded Server Configuration?
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 will you force database to use particular rollback segment?
How can we plan storage for very large tables ?
What is Database Buffers ?
How the log writer writes the data into database