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  




Categories