What is Shared Pool?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to define Data Block size in Oracle?

858


What is an Oracle SYSTEM tablespace and when is it Created?

835


Teradata: How can we know the indexed column in a table?

1551


What is an Oracle Rollback Segment?

854


Can a Tablespace hold objects from different Schemes in Oracle?

800


What are the consideration at tehe migration of Oracle 9i to 10G.

2723


What is the use of Oracle Control File?

799


What is an Oracle Data Segment?

804


What is the function of Redo Log in Oracle?

851


What is an oracle database schema?

840


What is an Oracle Data Dictionary?

833


What are Oracle Schema Objects?

840


What is an Integrity Constrains in Oracle?

921


Can a View based on another View in Oracle?

824


What are the uses of Oracle Rollback Segment?

869