What is a shared pool?
Submitted by: AdministratorThe Shared Pool environment contains both fixed and variable structures. The Fixed structures remain relatively the same size, whereas the variable structures grow and shrink based on user and program requirements.
Used To Store
Most Recently Executed SQL Statements
Most Recently used Data definitions
It Consists of two Key performance - related memory structures
Library Cache & Data Dictionary Cache
Shared Pool is sized by SHARED_POOL_SIZE
Submitted by: Administrator
Used To Store
Most Recently Executed SQL Statements
Most Recently used Data definitions
It Consists of two Key performance - related memory structures
Library Cache & Data Dictionary Cache
Shared Pool is sized by SHARED_POOL_SIZE
Submitted by: Administrator
Read Online Memory Management Job Interview Questions And Answers
Top Memory Management Questions
☺ | How does Space allocation table place within a block? |
☺ | What is the role of PCTFREE parameter is storage clause? |
☺ | What is the use of INDEXES option in IMP command? |
☺ | What is the OPTIMAL parameter? |
☺ | What is the significance of having storage clause? |
Top DB Oracle Categories
☺ | Oracle PL-SQL Interview Questions. |
☺ | Oracle DBA Interview Questions. |
☺ | Oracle D2K Interview Questions. |
☺ | OCI Interview Questions. |
☺ | Forms Reports Interview Questions. |