Interested to Buy Any Domain ? << Click Here >> for more details...
What is a Shared SQL pool ?
- 2 Answers
- 7157 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 |
What a SELECT FOR UPDATE cursor represent.?
what are views?
What is materialized view in Oracle?
What is rowid and rownum in oracle?
What is an Index Segment ?
How to use windows user to connect to the server?
What is the difference between implicit index and explicit index?
What does ROLLBACK do ?
What is meant by redo log buffer ?
what are archived logs?
How would you extract DDL of a table without using a GUI tool?
What is the purpose of save points in oracle database?
Oracle General 
