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 |
List the Optional Flexible Architecture (OFA) of Oracle database ?
What is the maximum size of a row in oracle 9i?
4 Answers Baidu, HCL, Yashu Systems,
What is function of RECO?
What is an Oracle Data Block?
What is an Integrity Constrains in Oracle?
• What is oracle Architecture?
List the factors that can affect the accuracy of the estimations ?
What Does DBWR do?
What is meant by Redo Log file mirrorring ? How it can be achieved?
What are Oracle Schema Objects?
Why query fails sometimes ?
What is the function of Dispatcher (Dnnn)?