View:   X$KSMMEM
         [K]ernal [S]torage [M]emory Management
            SGA [MEM]ory map of the entire SGA

 Column          Type               Description
 --------        ----               --------
 ADDR            RAW(4|8)           address of this row/entry in the array or SGA
 INDX            NUMBER             index number of this row in the fixed table array
 INST_ID         NUMBER       8.x   oracle instance number
 KSMMMVAL        RAW(4|8)           Actual value of data at this address.

Notes:

fixed table of the SGA, note that if the sga is not contiguous this fixed
table may not work correctly.

Access using either INDX or ADDR=hextoraw('address')

该表格为SGA区的映射值,表示了该内存区域的值。

可以和x$ksmfsv关联得到具体地址所代表的名字:
SQL> desc x$Ksmfsv
 Name                                      Null?    Type
 ----------------------------------------- -------- -------------------------

 ADDR                                               RAW(4)
 INDX                                               NUMBER
 INST_ID                                            NUMBER
 KSMFSNAM                                           VARCHAR2(64)
 KSMFSTYP                                           VARCHAR2(64)
 KSMFSADR                                           RAW(4)
 KSMFSSIZ                                           NUMBER

以下SQL语句可以建立关联:
select a.ksmfsnam,a.ksmfstyp,b.ksmmmval,a.ksmfssiz from x$ksmfsv a,x$ksmmem b
where a.ksmfsadr=b.addr;

但是在我测试的10.2.0.3中会出现错误,似乎对于x$ksmmem仅仅可以进行简单select,涉及到以下语句同样会出错:
create table ksmmem as select * from x$ksmmem;

如果要完成,则需要spool出结果,然后建立外部表连接才可以,当然这个过程中可能内存值发生了变化。



Related posts

coded by nessus
分享:  DeliciousGReader鲜果豆瓣CSDN网摘
Trackback

only 1 comment untill now

  1. regimes@loveliness.cute” rel=”nofollow”>.…

    ñïñ çà èíôó….

Add your comment now

无觅相关文章插件