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 is the role of archiever

4 Answers   TCS, Satyam, Baidu,

How will you monitor the space allocation ?

3 Answers  

What is use of Rollback Segments In Database ?

4 Answers  

What are functions of PMON?

5 Answers  

What is hit ratio ?

13 Answers   Indiabulls, RGPV,

How will you force database to use particular rollback segment?

1 Answers  

What is Cursor?

2 Answers  

What is the maximum size of a oracle9i database?

1 Answers   TCS, HCL, Baidu,

What is the maximum number of Lock Processes used?

1 Answers  

What does LGWR do?

2 Answers  

What is SGA?

3 Answers  

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

2 Answers