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 |
How to invoke the data pump export utility?
Define Transaction ?
Draw E-R diagram for many to many relationship ?
What operating systems are supported by oracle database 10g xe?
How can I combine multiple rows into a comma-delimited list in oracle?
What is data file?
How to get a list of all tables in the database?
Can select statements be used on views in oracle?
how to make an oracle object
difference between imlicit cursor and explicit cursor ?
What is an Oracle sequence?
What is define in oracle?