Interested to Buy Any Domain ? << Click Here >> for more details...
What is Shared Pool?
- 3 Answers
- 6094 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / jeby sebastian
Memory area of oracle which consists of Library cache
(recently executed sql and pl/sql statements) and Data
Dictionary cache(recently used tables and indexes).
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / shaikh asif
IT IS A MEMORY STRUCTURE WHICH CONTAINS
1.)LIBRARY CACHE(HOLDS RECENTLY EXECUTED PL/SQL COMMANDS)
2.)DATA DICTIONARY CACHE(HOLDS ALL RECENTLY EXECUTED DDL
COMMANDS);
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / ravi dutta
shared pool contains both the data dictionary and the
library cache which are used for checking the syntax and the
execution plan respectively.
| Is This Answer Correct ? | 1 Yes | 1 No |
What is PGA?
What do Redo Log Buffers contain?
What is Shared SQL Area?
How can we plan storage for very large tables ?
what is ORACLE MEMORY STRUCTURES
What is SGA?
How will you swap objects into a different table space for an existing database?
What is the function of Dispatcher (Dnnn)?
What is the use of Oracle Control File?
What does LGWR do?
What Does DBWR do?
What are the consideration at tehe migration of Oracle 9i to 10G.
Oracle General 
