基本命令：
alter session set events 'immediate trace name library_cache level ll';
其中ll代表level级别,对于9.2.0及以后版本,不同level含义如下:
level =1 ,转储library cache统计信息
level =2 ,转储hash table概要
level =4 ,转储library cache对象，只包含基本信息
level =8 ,转储library cache对象，包含详细信息(包括child references,pin waiters等)
level =16,增加heap sizes信息
level =32,增加heap信息
library cache由一个hash表组成,而hash表是一个由hash buckets组成的数组.
每个hash bucket都是包含library cache handle的一个双向链表。
library cache handle指向library cache object和一个引用列表.
library cache对象进一步分为:依赖表、子表和授权表等
我们看一下library cache的结构:
通过
alter session set events 'immediate trace name library_cache level 4'
获得以下输出(这部分信息来自oracle8i,trace文件可以从www.eygle.com上找到)
点击这里下载:
hsbi_ora_4614.trc
第一部分(等价于level 1):
library cache statistics:
gets hit ratio pins hit ratio reloads invalids namespace
---------- --------- ---------- --------- ---------- ---------- ---------
619658171 0.9999160 2193292112 0.9999511 9404 380 crsr
79698558 0.9998832 424614847 0.9999108 13589 0 tabl/prcd/type
163399 0.9979926 163402 0.9978948 16 0 body/tybd
0 0.0000000 0 0.0000000 0 0 trgr
34 0.0294118 35 0.0571429 0 0 indx
18948 0.9968862 24488 0.9953855 0 0 clst
0 0.0000000 0 0.0000000 0 0 obje
0 0.0000000 0 0.0000000 0 0 pipe
0 0.0000000 0 0.0000000 0 0 lob
0 0.0000000 0 0.0000000 0 0 dir
0 0.0000000 0 0.0000000 0 0 queu
0 0.0000000 0 0.0000000 0 0 objg
0 0.0000000 0 0.0000000 0 0 prop
0 0.0000000 0 0.0000000 0 0 jvsc
0 0.0000000 0 0.0000000 0 0 jvre
0 0.0000000 0 0.0000000 0 0 robj
0 0.0000000 0 0.0000000 0 0 reip
0 0.0000000 0 0.0000000 0 0 cpob
115071 0.9992179 115071 0.9930999 704 0 evnt
0 0.0000000 0 0.0000000 0 0 summ
0 0.0000000 0 0.0000000 0 0 dimn
0 0.0000000 0 0.0000000 0 0 ctx
0 0.0000000 0 0.0000000 0 0 outl
0 0.0000000 0 0.0000000 0 0 ruls
0 0.0000000 0 0.0000000 0 0 rmgr
0 0.0000000 0 0.0000000 0 0 unused
0 0.0000000 0 0.0000000 0 0 ppln
0 0.0000000 0 0.0000000 0 0 pcls
0 0.0000000 0 0.0000000 0 0 subs
0 0.0000000 0 0.0000000 0 0 locs
0 0.0000000 0 0.0000000 0 0 rmob
0 0.0000000 0 0.0000000 0 0 rsmd
699654181 0.9999117 2618209955 0.9999440 23713 380 cumulative
|
这部分信息也就是v$librarycache中显示的.
第二部分(等价于level 2中的输出):
library cache hash table: size=509 count=354
bucket 0:
bucket 1:
bucket 2: *
bucket 3:
bucket 4:
bucket 5: *
bucket 6: *
bucket 7:
bucket 8: **
bucket 9: ***
bucket 10: *
bucket 11: *
bucket 12: ***
bucket 13: *
bucket 14: *
bucket 15:
bucket 16: *
bucket 17:
bucket 18: *
bucket 19:
bucket 20:
bucket 21: *
bucket 22:
bucket 23:
bucket 24: *
bucket 25:
bucket 26:
bucket 27: ***
bucket 28:
bucket 29: **
bucket 30:
bucket 31:
bucket 32: ***
bucket 33: *
bucket 34:
bucket 35:
bucket 36: **
bucket 37:
bucket 38: **
bucket 39: *
bucket 40: *
bucket 41:
bucket 42:
bucket 43:
bucket 44:
bucket 45:
bucket 46: ****
bucket 47:
bucket 48:
bucket 49: *
bucket 50: *
bucket 51:
bucket 52: ***
bucket 53: **
bucket 54:
bucket 55: *
bucket 56:
bucket 57:
bucket 58:
bucket 59: *
bucket 60: **
bucket 61:
bucket 62: *
bucket 63:
bucket 64: *
bucket 65:
bucket 66:
bucket 67: *
bucket 68:
bucket 69: **
bucket 70:
bucket 71:
bucket 72: *
bucket 73:
bucket 74:
bucket 75: *
bucket 76: **
bucket 77:
bucket 78: ****
bucket 79:
bucket 80: *
bucket 81: *
bucket 82:
bucket 83: **
bucket 84: *
bucket 85:
bucket 86:
bucket 87:
bucket 88:
bucket 89: *
bucket 90: *
bucket 91:
bucket 92: *
bucket 93: *
bucket 94: *
bucket 95:
bucket 96: *
bucket 97:
bucket 98:
bucket 99: ***
bucket 100: *
bucket 101:
bucket 102: *
bucket 103:
bucket 104: *
bucket 105:
bucket 106:
bucket 107: ****
bucket 108:
bucket 109:
bucket 110:
bucket 111: *
bucket 112: **
bucket 113:
bucket 114:
bucket 115:
bucket 116: *
bucket 117:
bucket 118: *****
bucket 119:
bucket 120: *
bucket 121:
bucket 122:
bucket 123:
bucket 124:
bucket 125: *
bucket 126:
bucket 127:
bucket 128: *
bucket 129:
bucket 130: *
bucket 131: *
bucket 132:
bucket 133:
bucket 134:
bucket 135: *
bucket 136:
bucket 137:
bucket 138:
bucket 139: *
bucket 140: *
bucket 141: *
bucket 142:
bucket 143: *
bucket 144:
bucket 145: ***
bucket 146:
bucket 147: *
bucket 148:
bucket 149:
bucket 150: **
bucket 151:
bucket 152:
bucket 153: *
bucket 154:
bucket 155:
bucket 156:
bucket 157:
bucket 158:
bucket 159:
bucket 160:
bucket 161:
bucket 162:
bucket 163:
bucket 164: *
bucket 165: *
bucket 166:
bucket 167:
bucket 168:
bucket 169:
bucket 170: **
bucket 171:
bucket 172: *
bucket 173:
bucket 174:
bucket 175: *
bucket 176: *
bucket 177:
bucket 178:
bucket 179:
bucket 180:
bucket 181: *
bucket 182:
bucket 183:
bucket 184:
bucket 185: *
bucket 186:
bucket 187:
bucket 188: **
bucket 189:
bucket 190: *
bucket 191: *
bucket 192:
bucket 193:
bucket 194: *
bucket 195: **
bucket 196: *
bucket 197: **
bucket 198: ****
bucket 199: *
bucket 200: *
bucket 201: *
bucket 202: **
bucket 203:
bucket 204:
bucket 205: **
bucket 206:
bucket 207:
bucket 208: *
bucket 209: **
bucket 210:
bucket 211: *
bucket 212: *
bucket 213: *
bucket 214:
bucket 215:
bucket 216:
bucket 217: *
bucket 218: *
bucket 219:
bucket 220:
bucket 221: *
bucket 222:
bucket 223: *
bucket 224:
bucket 225:
bucket 226: *
bucket 227:
bucket 228: *
bucket 229: **
bucket 230: *
bucket 231:
bucket 232: **
bucket 233:
bucket 234: *
bucket 235: *
bucket 236:
bucket 237:
bucket 238: *
bucket 239:
bucket 240: **
bucket 241: **
bucket 242: **
bucket 243: ***
bucket 244:
bucket 245: *
bucket 246:
bucket 247:
bucket 248: **
bucket 249:
bucket 250:
bucket 251: **
bucket 252:
bucket 253: *
bucket 254: *
bucket 255:
bucket 256:
bucket 257: **
bucket 258: *
bucket 259:
bucket 260:
bucket 261: *
bucket 262: **
bucket 263: ***
bucket 264:
bucket 265: *
bucket 266:
bucket 267: *
bucket 268: *
bucket 269:
bucket 270:
bucket 271: **
bucket 272: *
bucket 273:
bucket 274: *
bucket 275: *
bucket 276: **
bucket 277:
bucket 278:
bucket 279:
bucket 280:
bucket 281: **
bucket 282: *
bucket 283: *
bucket 284: *
bucket 285: *
bucket 286:
bucket 287: *
bucket 288:
bucket 289:
bucket 290: **
bucket 291:
bucket 292: *
bucket 293:
bucket 294: *
bucket 295:
bucket 296: *
bucket 297:
bucket 298:
bucket 299: **
bucket 300: *
bucket 301:
bucket 302: *
bucket 303: *
bucket 304: **
bucket 305: **
bucket 306:
bucket 307:
bucket 308: *
bucket 309:
bucket 310:
bucket 311: **
本文关键：关于shared pool的深入探讨(三)
本站最佳浏览方式为 分辨率 1024x768 IE 6.0（或更高版本的 IE浏览器） 
|