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 candidate key & super key
6. Display the client name and order date for all orders using the traditional method.
Explain the blob datatype?
WHAT IS ecc 6.0
What is Parallel Server ?
How do you ensure database security?
What are the differences between primary key and unique key?
What are the different approaches used by Optimizer in choosing an execution plan ?
Define oracle database
Describe Referential Integrity ?
Explain about your project and its relation to the current job position you are applying to?
What is self-referential integrity constraint ?