Interested to Buy Any Domain ? << Click Here >> for more details...
What is Shared Pool?
- 3 Answers
- 6082 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 an Integrity Constrains in Oracle?
What are the components of SGA?
What is Dedicated Server Configuration?
What is Shared Pool?
Can a Tablespace hold objects from different Schemes in Oracle?
How to calculate the approximate size of the SGA based on the size of the block,shared_pool,redo_buffer_cache and db_buffer_cache?
What is Shared SQL Area?
How to find the current session sid
What is the functionality of SYSTEM table space ?
what is ORACLE MEMORY STRUCTURES
how oracle will recognise its space is 100gb if 100gb is allocated for it...
What is the function of Dispatcher (Dnnn)?
Oracle General 
