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 ORACLE MEMORY STRUCTURES

3 Answers  


How does Space allocation table place within a block ?

1 Answers  


How the log writer writes the data into database

4 Answers   Satyam, Baidu,


How many Dispatcher Processes are created?

1 Answers  


What is SGA?

3 Answers  


What is Shared SQL Area?

1 Answers   Oracle,


How will you swap objects into a different table space for an existing database?

2 Answers  


What is the function of ARCH?

3 Answers  


What is the OPTIMAL parameter ?

1 Answers   TCS,


What is a Multi-threaded Server Configuration?

1 Answers  


What is function of RECO?

1 Answers  


When will be a segment released?

1 Answers  




Categories