Message-ID: <F001.005D63F2.20031111015434@fatcity.com>
Date: Tue, 11 Nov 2003 01:54:34 -0800
To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
Sender: ml-errors@fatcity.com
Reply-To: ORACLE-L@fatcity.com
Errors-To: ML-ERRORS@fatcity.com
From: "Satav, Pawan" <pawan.satav@cgey.com>
Subject: RE: what is in the UGA?
Organization: Fat City Network Services, San Diego, California
Precedence: bulk
Mime-Version: 1.0
Content-Type: text/plain;	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Good info Steve.

But what I want to ask is what is a CGA  ?


Regards
Pawan


-----Original Message-----
Sent: Tuesday, November 11, 2003 1:24 PM
To: Multiple recipients of list ORACLE-L


Hi Ryan,

The words "session specific" have to do with the difference between a 
process and a session. Many Oracle environments run with just one user
session per process, but in general there can be multiple user sessions
being serviced by a single process.

The UGA holds persistent data structures that are specific to a particular
session (even though other sessions may be connected through the same
process). By contrast, the PGA contains persistent data structures that are
specific to the process (not general to the instance) but must be visible to
all sessions connected via that process, and the CGA holds transient data
structures that are only required for the duration of a single call.

The UGA consists of a small fixed area containing a few atomic variables,
small data structures and pointers. The rest of the UGA is a heap. Most of
the UGA heap is for private SQL and PL/SQL areas. So yes, package variables
and bind variable are there (although the bind meta-data is in the SGA) but
sort areas, row source buffers, and runtime state data are also major space
consumers.

@   Regards,
@   Steve Adams
@   http://www.ixora.com.au/         - For DBAs
@   http://www.christianity.net.au/  - For all 

-----Original Message-----
ryan_oracle@cox.net
Sent: Tuesday, 11 November 2003 12:14 AM
To: Multiple recipients of list ORACLE-L


I cant find any specifics in the docs. I must be missing something. All I
see is 'session specific information'?

Does this mean package variables? SQLPLUS bind variables? What does this
mean? 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Steve Adams
  INET: steve.adams@ixora.com.au

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

____________________________________________________
This message contains information that may be privileged or confidential and
is the property of the Cap Gemini Ernst & Young Group. It is intended only
for the person to whom it is addressed. If you are not the intended
recipient, you are not authorised to read, print, retain, copy, disseminate,
distribute, or use this message or any part thereof. If you receive this
message in error, please notify the sender immediately and delete all copies
of this message.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Satav, Pawan
  INET: pawan.satav@cgey.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).