有意思的问题:
我这里的情况是 session uga memory max > session pga memory max
TOM say
edicated servers allocate their UGA out of the PGA (backend processes and
such).
so UGA may issmaller than PGA if system is running on dedicated server.
SQL> col name format a30
SQL> /
STATISTIC# NAME
CLASSVALUE
---------- ------------------------------ ---------- ----------
9 session logical reads
1 511509
10 session stored procedure space
1
0
12 CPU used by this session
1 2506
13 session connect time
1 1225541128
15 session uga memory
12459504
16 session uga memory max
1128528600
20 session pga memory
1 25263224
21 session pga memory max
1 25582304
213 session cursor cache hits
64 2900
214 session cursor cache count
64
4
10 rows selected.
SQL> select * from v$version
2where rownum< 2;
BANNER
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production