In Oracle
PGA is specific to operation system process or thread that is not shared by
the other process or threads and it is process specific, it could not establish
in SGA.
PGA is a heap that contains session
dependent variables required by a dedicated or shard server process, server
process allocates memory structures that requires in PGA.
Private
Sql Area:
A
private sql area contains the information about
parsed sql statements and other session specific information for processing.
When a server process executes a sql or pl/sql statements/codes the process
uses the private sql area to store the bind variable values, query execution state
information and query execution work areas.
Private sql area can be placed Program global
are (PGA) in dedicated server architecture, In shared server architecture
private sql area creates at SGA.
0 $type={blogger}:
Post a Comment