Originally posted by jmodic
Some additional notes to additional notes....
Originally posted by Shestakov
1. sort_area --> part of PGA not UGA:
I think best resources regarding sorting can be found in Steve Adams and/or Jonathan Lewis's book and their web sites. Here are some links to their thoughts about sorting:

http://www.ixora.com.au/newsletter/2000_11.htm
http://www.ixora.com.au/q+a/0011/08114657.htm
http://www.jlcomp.demon.co.uk/faq/uga.html
I also can red Tom Kyte "expert one to one", page 89.
"... Each dedicated/shared server has PGA. ... It is sort area, hash area ..."
and
"Oracle 24x7" by Venkat Devraj, page 328.

So sort area, hash area --> part of PGA, Not UGA.
About script:
I had to used ur scripts. This is results:

Connected to:
Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production
With the Partitioning option
JServer Release 9.0.1.1.1 - Production

SQL> select a.name, b.value
2 from v$statname a, v$mystat b
3 where a.statistic# = b.statistic#
4 and a.name like 'session _ga%';

NAME VALUE
---------------------------------------------------------------- ----------
session uga memory 76240
session uga memory max 76240
session pga memory 230456
session pga memory max 230456

SQL> select count(*) from (select 1 from dba_objects order by object_name);

COUNT(*)
----------
40617

SQL> select a.name, b.value
2 from v$statname a, v$mystat b
3 where a.statistic# = b.statistic#
4 and a.name like 'session _ga%';

NAME VALUE
---------------------------------------------------------------- ----------
session uga memory 70480
session uga memory max 631328
session pga memory 1303004
session pga memory max 1303004


SQL> alter session set sort_area_size=4000000;
-- ~ 4M

Session altered.

SQL> select a.name, b.value
2 from v$statname a, v$mystat b
3 where a.statistic# = b.statistic#
4 and a.name like 'session _ga%';

NAME VALUE
---------------------------------------------------------------- ----------
session uga memory 71456
session uga memory max 631328
session pga memory 1303004
session pga memory max 1303004

SQL> select count(*) from (select 1 from dba_objects order by object_name);

COUNT(*)
----------
40617

SQL> select a.name, b.value
2 from v$statname a, v$mystat b
3 where a.statistic# = b.statistic#
4 and a.name like 'session _ga%';

NAME VALUE
---------------------------------------------------------------- ----------
session uga memory 71544
session uga memory max 1878200
session pga memory 2103132
session pga memory max 2103132

PGA (NOT PGA MAX) increased from 1303004 to 2103132.
real (not max!) uga increaced from 70480 to 71456.

I have respect for you. But this is my mind.
I have instance, that has ~ 1000 connections
(800-900 thru shared server and 50-100 dedicated)
and 6GB memory.
And PGA/UGA is my headache, sometimes.

[Edited by Shestakov on 07-02-2002 at 12:08 AM]