why the TABLE/PROCEDURE gets

From: biti_rainy <biti_rainy_at_itpub.net>
Date: Tue, 28 Sep 2004 14:44:52 +0800
Message-Id: <20040928064553.D3D9B72C10B@turing.freelists.org>

hi,all

TABLE/PROCEDURE 4898102 4781103 0.976113400 2810388 2496178 0.888196932 4898102(gets) > 2810388(pins)

do a gets but not to do a pins ?how to explain it ?

SQL> select namespace,gets,gethits,gethitratio,pins,pinhits,pinhitratio 2 from v$librarycache;

NAMESPACE GETS GETHITS GETHITRATIO PINS PINHITS PINHITRATIO --------------- ---------- ---------- ----------- ---------- ---------- -----------

SQL AREA           7395468    7282143 0.984676426   69283112   68892802 0.994366448
TABLE/PROCEDURE    4898102    4781103 0.976113400    2810388    2496178 0.888196932
BODY                  6528       6371 0.975949754       6185       5779 0.934357316
TRIGGER               2154       1858 0.862581244       2319       1829 0.788702026
INDEX                37119      16912 0.455615722      37546      16855 0.448915996
CLUSTER              11525      11467 0.994967462      11842      11731 0.990626583
OBJECT                   0          0           1          0          0           1
PIPE                  6648       6542 0.984055354       9729       9623 0.989104738

sys_at_OCN>select VIEW_DEFINITION from V$FIXED_VIEW_DEFINITION where view_name = 'GV$LIBRARYCACHE';

VIEW_DEFINITION

select inst_id, decode(indx,0,'SQL AREA',1,'TABLE/PROCEDURE',2,'BODY',3,'TRIGGER', 4,'INDEX',5,'CLUS TER',6,'OBJECT',7,'PIPE', 13,'JAVA SOURCE',14,'JAVA RESOURCE',32,'JAVA DATA','?'), kglstget,kglstght , decode(kglstget,0,1,kglstght/kglstget),kglstpin,kglstpht, decode(kglstpin,0,1,kglstpht/kglstpin),k glstrld,kglstinv, kglstlrq,kglstprq,kglstprl,kglstirq,kglstmiv from x$kglst where indx<8 or indx=13 or indx=14 or indx=32

sys_at_OCN>select count(*) from x$kglst;

COUNT(*)

64
sys_at_OCN>desc x$kglst;

 Name                                                  Null?    Type
 ----------------------------------------------------- -------- ------------------------------------
 ADDR                                                           RAW(4)
 INDX                                                           NUMBER
 INST_ID                                                        NUMBER
 KGLSTGET                                                       NUMBER
 KGLSTGHT                                                       NUMBER
 KGLSTPIN                                                       NUMBER
 KGLSTPHT                                                       NUMBER
 KGLSTRLD                                                       NUMBER
 KGLSTINV                                                       NUMBER
 KGLSTLRQ                                                       NUMBER
 KGLSTPRQ                                                       NUMBER
 KGLSTPRL                                                       NUMBER
 KGLSTIRQ                                                       NUMBER
 KGLSTMIV                                                       NUMBER

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Sep 28 2004 - 01:41:29 CDT

why the TABLE/PROCEDURE gets > pins