What is Shared SQL Area?

Question Posted / guest

1 Answers
7361 Views
Oracle, I also Faced
E-Mail Answers

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 Oracle Architecture Interview Questions

THE MAIN CONCEPT OF PROGRAMMIN TYPE?

1 Answers

What is a Parallel Server option in ORACLE?

1 Answers

How to find the SGA Size

7 Answers Baidu, Reliance,

what is ORACLE MEMORY STRUCTURES

3 Answers

What is a Control file ?

4 Answers

How will you monitor rollback segment status ?

2 Answers

How will you create multiple rollback segments in a database ?

1 Answers

How to find the current session sid

3 Answers Baidu,

What is the OPTIMAL parameter ?

1 Answers TCS,

How to calculate the approximate size of the SGA based on the size of the block,shared_pool,redo_buffer_cache and db_buffer_cache?

0 Answers

How can we plan storage for very large tables ?

1 Answers

What is the use of Oracle Control File?

0 Answers

For more Oracle Architecture Interview Questions Click Here