What is Shared SQL Area?

Question Posted / guest

1 Answers
7156 Views
Oracle, I also Faced
E-Mail Answers

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

Post New Answer

More Oracle Architecture Interview Questions

How does Space allocation table place within a block ?

1 Answers

What is the function of Lock (LCKn) Process?

1 Answers

What is the maximum size of a oracle9i database?

1 Answers Baidu, HCL, TCS,

What is an Oracle Data Dictionary?

0 Answers

What are the uses of Oracle Rollback Segment?

0 Answers

How to find the SGA Size

7 Answers Baidu, Reliance,

What is a Multi-threaded Server Configuration?

1 Answers

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?

0 Answers

How will you force database to use particular rollback segment?

1 Answers

How can we plan storage for very large tables ?

1 Answers

What is Database Buffers ?

4 Answers

How the log writer writes the data into database

4 Answers Baidu, Satyam,

For more Oracle Architecture Interview Questions Click Here