Interested to Buy Any Domain ? << Click Here >> for more details...
What is Shared Pool?
- 3 Answers
- 6193 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 SGA?
How many Dispatcher Processes are created?
What does LGWR do?
What is hit ratio ?
Can a Tablespace hold objects from different Schemes in Oracle?
How will you monitor rollback segment status ?
Which parameter in Storage clause will reduce no. of rows per block?
Name the ORACLE Background Process?
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?
How does Space allocation table place within a block ?
What are the consideration at tehe migration of Oracle 9i to 10G.
When will be a segment released?
Oracle General 
