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  




Categories