| Share this post! | Vote this! |
|
Oracle uses three kinds of memory structures
SGA (System Global Area) : is a large part of memory that all the oracle background processes access.
PGA (Process Global Area) : This is memory that is private to a single process or thread and is not accessible by any other process or thread
UGA (User Global Area) :
This is memory that is assoicated with your session, it can be found in the PGA or SGA depending on whether you are connected to the database via shared server
Shared Server - the UGA will be in the SGA
Dedicated Server - the UGA will be in the PGA more...
SGA (System Global Area) : is a large part of memory that all the oracle background processes access.
PGA (Process Global Area) : This is memory that is private to a single process or thread and is not accessible by any other process or thread
UGA (User Global Area) :
This is memory that is assoicated with your session, it can be found in the PGA or SGA depending on whether you are connected to the database via shared server
Shared Server - the UGA will be in the SGA
Dedicated Server - the UGA will be in the PGA more...
0 comments:
Post a Comment