<<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
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?...............
Describe Oracle architecture in brief, What is the function of
SMON?, Explain different types of segment, Explain SGA memory
structures..............
Session auditing, Statement auditing, Privilege auditing, Object
auditing.............
Describe the Oracle backup, i.e. archive log mode, cold and hot
backups, incremental backups...............
|
