What is Shared Pool?
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 are the two types of Server Configurations?
How free extents are managed in Ver 6.0 and Ver 7.0 ?
What is hit ratio ?
What is meant by Redo Log file mirrorring ? How it can be achieved?
When does LGWR write to the database?
Which parameter in Storage clause will reduce no. of rows per block?
What is the maximum size of a row in oracle 9i?
4 Answers Baidu, HCL, Yashu Systems,
How to find the current session sid
How does Space allocation table place within a block ?
What is a Rollback segment entry ?
How will you estimate the space required by a non-clustered tables?
How will you force database to use particular rollback segment?