What is a Shared SQL pool ?
- 2 Answers
- 6370 Views
- I also Faced
- E-Mail Answers
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 |
Explain what does a control file contain?
various types of hints and their usage
What is DTS and purpose of DTS ?
what are the things that you consider while creating indexes on partitioning tables?
What is an external table?
What are the different types of modules in oracle forms?
8. Display the client name and order date for all orders using the natural join keywords.
How to turn on or off recycle bin for the instance?
What are group functions in oracle?
What is Index Cluster ?
what are steps for interface? where is exchange rate defined in which table?
What is key preserved table?
Oracle General 
