Home » RDBMS Server » Server Administration » uga, pga
uga, pga [message #860] Sat, 09 March 2002 05:40 Go to next message
abeignner
Messages: 1
Registered: March 2002
Junior Member
hello everyone,
somebody can describe UGA,PGA there differnce and functions.
or guide me to a site.
Re: uga, pga [message #1417 is a reply to message #860] Sat, 27 April 2002 11:31 Go to previous message
Susan
Messages: 102
Registered: October 2001
Senior Member
PGA is program global area and UGA is user global area.
UGA concept mainly comes in shared servers where large pool is not configured. It stores the session and cursor informations. It comes in Shared pool of the SGA(system global area or shared global area).
PGA is a memory which stores info about data and control informations for a single server process.It comes in a dedicated server configuration.
Previous Topic: Oracle not available
Next Topic: Re: ocp *.* - dumps,braindumps,kits,cbt,tbt,sts......
Goto Forum:
  


Current Time: Mon Sep 09 18:29:50 CDT 2024