What is a Shared SQL pool ?
Answers were Sorted based on User's Feedback
Answer / sawant
The data dictionary cache is stored in an area in SGA called
the Shared SQL Pool. This will allow sharing of parsed
SQL statements among concurrent users.
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / rashid ansari
shared pool contain data dictionary and library
cache.oracle make a execution plan into sheared pool
| Is This Answer Correct ? | 1 Yes | 2 No |
What is data block in Oracle?
How to build data dictionary view an new database?
"primary key=unique+null" is equal,reson?not,reason?
What is where clause in oracle?
How different is ms access and oracle?
What is forall Statement ?
Describe Referential Integrity ?
How to use existing values in update statements using oracle?
Differentiate between TRUNCATE and DELETE?
What is oracle open database communication (odbc)?
How will you identify oracle database software release?
what is the use of rank function?