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 see free space of each tablespace?
How to use like conditions in oracle?
ex. one table is having 1 column with 10 records , then how to display all the values in row wise ?
How do we get field detail of a table?
sql command 2 know current database
How to empty your oracle recycle bin?
How to establish administrator authentication to the server?
List out the difference between commit, rollback, and savepoint?
What is Private Database Link ?
How to write text literals in oracle?
How many categories of data types in oracle?
How to retrieve the count of updated rows?