buffer header - cheeyoung/sqlplus-public GitHub Wiki
X$BH
indx | |
ts# | |
file# | |
dbarfil | |
dbablk | |
obj | |
tch |
...
42
43 *** 2015-05-22 09:27:57.836
44 BH (0x4abb48450) file#: 77 rdba: 0x13552a84 (77/1387140) class: 8 ba: 0x4a8808000
45 set: 45 pool: 3 bsz: 8192 bsi: 0 sflg: 0 pwc: 0,25
46 dbwrid: 0 obj: 123486 objn: -1 tsn: [0/8] afn: 77 hint: f
47 hash: [0x733b74860,0x8edbb03a8] lru: [0x75fbc9700,0x5afb39628]
48 ckptq: [NULL] fileq: [NULL]
49 objq: [0x4f3b0fd28,0x743d064b0] objaq: [0x75fbc9738,0x5afb39660]
50 st: XCURRENT md: NULL fpin: 'ktslwhh3: ktsla_rbk_ins_chunk' fscn: 0x746.2910706b tch: 125 le: 0x65bf72868
51 flags:
52 LRBA: [0x0.0.0] LSCN: [0x0.0] HSCN: [0xffff.ffffffff] HSUB: [65535]
53 Dump of buffer cache at level 10 for pdb=0 tsn=8 rdba=324348548
54 BH (0x4abb48450) file#: 77 rdba: 0x13552a84 (77/1387140) class: 8 ba: 0x4a8808000
55 set: 45 pool: 3 bsz: 8192 bsi: 0 sflg: 0 pwc: 0,25
56 dbwrid: 0 obj: 123486 objn: -1 tsn: [0/8] afn: 77 hint: f
57 hash: [0x733b74860,0x8edbb03a8] lru: [0x75fbc9700,0x5afb39628]
58 ckptq: [NULL] fileq: [NULL]
59 objq: [0x4f3b0fd28,0x743d064b0] objaq: [0x75fbc9738,0x5afb39660]
60 st: XCURRENT md: NULL fpin: 'ktslwhh3: ktsla_rbk_ins_chunk' fscn: 0x746.2910706b tch: 125 le: 0x65bf72868
61 flags:
62 LRBA: [0x0.0.0] LSCN: [0x0.0] HSCN: [0xffff.ffffffff] HSUB: [65535]
63 GLOBAL CACHE ELEMENT DUMP (address: 0x65bf72868):
64 id1: 0x152a84 id2: 0x4d pkey: OBJ#0,8,123486 block: (77/1387140)
65 lock: X rls: 0x0 acq: 0x0 latch: 12 lms: 1
66 flags: 0x20 fair: 0 recovery: 0
67 bscn: 0x746.29100093 bctx: 0x0 scan: 0x0
68 lcp: 0x0 lnk: [NULL] lch: [0x4abb48590,0x4abb48590]
69 seq: 30216 hist: 67 143:0 85 16 352 197 48 121 67 143:0 85 16 352 197 48
...
...
78427 BH (0xc00000589dc23b20) file#: 426 rdba: 0x6a86ebf5 (426/453621) class: 7312 ba: 0xc00000588690c000
78428 set: 141 pool: 3 bsz: 8192 bsi: 0 sflg: 0 pwc: 5730,25
78429 dbwrid: 0 obj: -1 objn: 0 tsn: [0/2] afn: 426 hint: f
78430 hash: [0xc00000073e1c42e0,0xc000008ff1853be8] lru: [0xc00000589dc22588,0xc00000589dc20530]
78431 ckptq: [NULL] fileq: [NULL]
78432 objq: [0xc0000055feb706e8,0xc00000883a8217b8] objaq: [0xc0000058fec03368,0xc00000589dc20568]
78433 use: [0xc000008fb4048250,0xc000008fb4048250] wait: [NULL]
78434 st: READING md: EXCL tch: 0 le: 0xc00000511f99ba28
78435 flags:
78436 Using State Objects
78437 ----------------------------------------
78438 SO: 0xc000008fb40481c8, type: 46, owner: 0xc00000887feb9258, flag: INIT/-/-/0x00 if: 0x1 c: 0x1
78439 proc=0xc0000090e6cddde0, name=buffer handle, file=kcb2.h LINE:3319 ID:, pg=0 conuid=0
78440 (buffer) PR: 0xc0000090e6cddde0 FLG: 0x0 SEQ: 0x1889620
78441 lock rls: 0x0000000000000000, class bit: 0x0
78442 scan scn: 0.0
78443 cr[0]:
78444 sh[0]:
78445 kcbbfbp: [BH: 0xc00000589dc23b20, LINK: 0xc000008fb4048250]
78446 type: normal pin
78447 where: ktuwh03: ktugnb, why: 0
78448 GLOBAL CACHE ELEMENT DUMP (address: 0xc00000511f99ba28):
78449 id1: 0x6ebf5 id2: 0x1aa pkey: TS#0,2 block: (426/453621)
78450 lock: C rls: 0x0 acq: 0x3 latch: 71 lms: 8
78451 flags: 0x20 fair: 0 recovery: 0
78452 bscn: 0x0.0 bctx: 0x0 scan: 0x0
78453 lcp: 0xc000008f3910f430 lnk: [0xc000008f3910f490,0xc000008f3910f490] lch: [0xc00000589dc23c60,0xc00000589dc23c60]
78454 seq: 8 hist: 208 352 329 143:6 71 208 352 32
78455 LIST SKIPPED (no latch)
78456 Buffer contents not dumped
78457 ----------------------------------------
...
V$CACHE displays information from the block header of each block in the SGA of the current instance as related to particular database objects. This is an Oracle Real Application Clusters view.