Interested to Buy Any Domain ? << Click Here >> for more details...
What is Shared Pool?
- 3 Answers
- 6075 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 Oracle Data Segment?
Why query fails sometimes ?
List the Optional Flexible Architecture (OFA) of Oracle database ?
How will you swap objects into a different table space for an existing database?
What is the significance of having storage clause ?
Can a View based on another View in Oracle?
Can a Tablespace hold objects from different Schemes in Oracle?
how oracle will recognise its space is 100gb if 100gb is allocated for it...
How to find the SGA Size
What is an Oracle Data Block?
What is the function of ARCH?
How will you force database to use particular rollback segment?
Oracle General 
