开发学院数据库 Oracle Oracle中Buffer Cache内存结构及监控阅读

Oracle中Buffer Cache内存结构及监控

　2007-05-12 12:24:11　来源：WEB开发网　　　

核心提示： BH (0x637F0720) file#: 1 rdba: 0x004011ed (1/4589) class 1 ba: 0x63570000………………………

BH (0x637F0720) file#: 1 rdba: 0x004011ed (1/4589) class 1 ba: 0x63570000
…………………………………
　hash: [64be8000,65a5eab4] lru: [637f06ac,637f0824]
　LRU flags: moved_to_tail
　ckptq: [NULL] fileq: [NULL]
…………………………………
BH (0x64BE8000) file#: 0 rdba: 0x00000000 (0/0) class 0 ba: 0x64800000
…………………………………
　hash: [65a5eab4,637f0720] lru: [64be8104,65aa3f0c]
…………………………………
BH (0x63BEC0A0) file#: 6 rdba: 0x0180b00a (6/45066) class 1 ba: 0x638B0000
　set: 3 dbwrid: 0 obj: 7087 objn: 7087
　hash: [65a9ccd4,65a9ccd4] lru: [63bec1a4,63bec02c]
　ckptq: [65abceb4,63bec66c] fileq: [65abcfbc,63becd10]
　st: XCURRENT md: NULL rsop: 0x00000000 tch: 1
　flags: buffer_dirty gotten_in_current_mode redo_since_read
　LRBA: [0xe9.229.0] HSCN: [0x0000.00122967] HSUB: [1] RRBA: [0x0.0.0]
BH (0x63BECAE8) file#: 6 rdba: 0x0180b009 (6/45065) class 4 ba: 0x638CC000
　set: 3 dbwrid: 0 obj: 7087 objn: 7087
　hash: [65a9cbcc,65a9cbcc] lru: [63becbec,63beca74]
　ckptq: [637fc250,63becdc4] fileq: [65ab8ad0,63becdcc]
　st: XCURRENT md: NULL rsop: 0x00000000 tch: 2
　flags: buffer_dirty gotten_in_current_mode redo_since_read
　LRBA: [0xe9.21b.0] HSCN: [0x0000.00122965] HSUB: [1] RRBA: [0x0.0.0]
…………………………………