oracle数据库uga中文全称,PGA和UGA稀饭了 - Oracle数据库管理 - Oracle数据库数据恢复、性能优化来问问AskMaclean - ParnassusData诗檀软件旗下网站...

UGA

===>

1. Fixed UGA  UGA Variables， Fixed UGA在session连接时分配并初始化

UGA Variables 变量用来方便访问UGA对象结构

2. UGA heap , uga heap要么是 top pga heap的子堆 (subheap)  (dedicated mode)，  要么是 shared pool heap 或者 large pool heap的子堆(shared mode)

The UGA is part of: The PGA when using dedicated servers The SGA when using multithreaded servers UGA heap information can be seen in X$KSMUP

X $KSMUP - [U]GA Hea[P]

x$ksmhp

SQL> create or replace view v$uga_subheaps as

2  select /*+use_nl(h,s)*/

3         h.ksmchds, u.ksmchcom

4  ,      h.ksmchcom ksmchnam

5  ,      h.ksmchsiz, h.ksmchcls, h.ksmchpar

6  from   x$ksmhp h, x$ksmup u

7  where  h.ksmchds = u.ksmchpar

8  and    u.ksmchcls like '%recr'

9  and    u.ksmchpar != hextoraw('00');

View created.

SQL> select distinct ksmchcom from  v$uga_subheaps;

KSMCHCOM

----------------

Alloc environm

koh-kghu sessi

dbgdInitEventG

PLS UGA hp

kxs-heap-p

kxs-heap-b

kxs-heap-d

kxs-heap-i

kxs-heap-w

dump UGA

SQL> oradebug setmypid;

Statement processed.

SQL> oradebug dump heapdump 4;

Statement processed.

SQL> oradebug tracefile_name

/s01/orabase/diag/rdbms/g11r23/G11R23/trace/G11R23_ora_12207.trc

top uga heap的 subheap之一是session heap

*** 2012-08-09 06:11:08.743

Processing Oradebug command 'dump heapdump 4'

******************************************************

HEAP DUMP heap name="session heap"  desc=0x2b1008a167c8

extent sz=0xffc8 alt=32767 het=32767 rec=0 flg=2 opc=3

parent=0xbaf9700 owner=0x11b845d98 nex=(nil) xsz=0x1e278 heap=(nil)

fl2=0x20, nex=(nil), dsxvers=1, dsxflg=0x0

dsx first ext=0x8a20098

EXTENT 0 addr=0x2b1008b67038

Chunk     2b1008b67048 sz=    64416    free      "               "

Chunk     2b1008b76be8 sz=     1048    freeable  "kxs-heap-p     "  ds=0x2b1008a30d00

EXTENT 1 addr=0x2b1008a40030

Chunk     2b1008a40040 sz=     4928    perm      "perm           "  alo=4928

Chunk     2b1008a41380 sz=      736    free      "               "

Chunk     2b1008a41660 sz=     1296    recreate  "kxs-heap-p     "  latch=(nil)

ds     2b1008a30d00 sz=     3392 ct=        3

2b1008b76be8 sz=     1048

2b1008a47ca0 sz=     1048

Chunk     2b1008a41b70 sz=      584    freeable  "kqdAllocFromUGA"

Chunk     2b1008a41db8 sz=     1048    freeable  "kxs-heap-p     "  ds=0x2b1008a503c8

Chunk     2b1008a421d0 sz=      176    free      "               "

Chunk     2b1008a42280 sz=     1016    freeable  "kgsc:kxsc      "

Chunk     2b1008a42678 sz=     1048    freeable  "kxs-heap-p     "  ds=0x2b1008a40f08

Chunk     2b1008a42a90 sz=     1048    recreate  "kxs-heap-p     "  latch=(nil)

ds     2b1008a31338 sz=     1048 ct=        1

不知道这样是否你可以 明白一点