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 Architecture Interview Questions

What Does DBWR do?

2 Answers   Honeywell,

How will you estimate the space required by a non-clustered tables?

2 Answers  

What is PGA?

5 Answers  

What is SGA?

3 Answers  

How will you monitor rollback segment status ?

2 Answers  

When does LGWR write to the database?

3 Answers  

What is User Process?

1 Answers  

What is use of Rollback Segments In Database ?

4 Answers  

How to find the SGA Size

7 Answers   Reliance, Baidu,

what is the role of archiever

4 Answers   TCS, Satyam, Baidu,

What are the two types of Server Configurations?

3 Answers  

How many Dispatcher Processes are created?

1 Answers