What is Shared Pool?
- 3 Answers
- 5254 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 |
How will you create multiple rollback segments in a database ?
What is use of Rollback Segments In Database ?
What is the function of Lock (LCKn) Process?
What is the significance of having storage clause ?
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 an Oracle SYSTEM tablespace and when is it Created?
What are the two types of Server Configurations?
how oracle will recognise its space is 100gb if 100gb is allocated for it...
How to find the current session sid
What is Cursor?
What is an Oracle Rollback Segment?
How to find the SGA Size
Oracle General 
