Interested to Buy Any Domain ? << Click Here >> for more details...
What is Shared Pool?
- 3 Answers
- 6054 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 functions of PMON?
What is the function of Lock (LCKn) Process?
List the Optional Flexible Architecture (OFA) of Oracle database ?
How will you estimate the space required by a non-clustered tables?
What is Server Process?
What are the two types of Server Configurations?
How the log writer writes the data into database
THE MAIN CONCEPT OF PROGRAMMIN TYPE?
How to implement the multiple control files for an existing database ?
What is Shared SQL Area?
Name the ORACLE Background Process?
Oracle General 
