Interested to Buy Any Domain ? << Click Here >> for more details...
What is a Shared SQL pool ?
- 2 Answers
- 7060 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 is the difference between alert log file and tarce file ?
How to rename a tablespace in oracle?
What are the execution control statements in oracle?
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
What are the advantages of Views ?
What is a trigger and what are its types in oracle?
How to create a table in a specific tablespace?
Which are the five query types available in oracle?
What is analyze command used for?
What is difference between truncate and delete?
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
What are the various types of snapshots ?
Oracle General 
