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  


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,