why the TABLE/PROCEDURE gets > pins
- From: "biti_rainy" <biti_rainy@xxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 28 Sep 2004 14:44:52 +0800
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@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@OCN>select count(*) from x$kglst;
COUNT(*)
----------
64
sys@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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » why the TABLE/PROCEDURE gets > pins
