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

How to implement the multiple control files for an existing database ?

2 Answers  


When will be a segment released?

1 Answers  


How many Dispatcher Processes are created?

1 Answers  


When Does DBWR write to the database?

6 Answers  


How can you find the size of a database?

5 Answers   HCL, Baidu,


What is Shared Pool?

3 Answers  


What is advantage of having disk shadowing/ Mirroring ?

1 Answers  


What is User Process?

1 Answers  


THE MAIN CONCEPT OF PROGRAMMIN TYPE?

1 Answers  


1.Explain the three levels with the help og a diagram.

1 Answers   Baidu,


What is a Rollback segment entry ?

3 Answers   TCS,


What is Shared SQL Area?

1 Answers   Oracle,




Categories