What is a shared pool?


What is a shared pool?

<<Previous  Next>>

Oracle - What is a shared pool? - Feb 23, 2010 at 11:00 PM by Rajmeet Ghai

What is a shared pool?

Shared pool in oracle contains cache information that collects, parses, interprets and executes SQL statements that goes against database. This shared pool acts like a buffer for these SQL statements.

Oracle - What is a shared pool? - Feb 07, 2010 at 14:20 PM by Shuchi Gauri

What is a shared pool?

The shared pool is a key component. The shared pool is like a buffer for SQL statements. It is to store the SQL statements so that the identical SQL statements do not have to be parsed each time they're executed.

Oracle - What is a shared pool? - April 10, 2009 at 11:00 AM

What is a shared pool?  

It is the area in SGA that allows sharing of parsed SQL statements among concurrent users. 

Also read

Oracle Backup and Recovery

What is configure command and recovery catalog?, What are different types of backup? (Hot, Cold, logical, Physical)?, Whats the Concept of Flashback Query in Oracle (10g in particular) and how is it beneficial?...............

Oracle architecture

Describe Oracle architecture in brief, What is the function of SMON?, Explain different types of segment, Explain SGA memory structures..............

Oracle auditing

Session auditing, Statement auditing, Privilege auditing, Object auditing.............

Oracle backup

Describe the Oracle backup, i.e. archive log mode, cold and hot backups, incremental backups...............

<<Previous  Next>>

Write your comment - Share Knowledge and Experience


Interview questions
Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us | We are hiring