首页 > Linux操作系统 > Linux操作系统 > x$bh


原创 Linux操作系统 作者:gpgp2010 时间:2012-05-17 13:49:13 0 删除 编辑
Mapping of GV$BH Columns to X$BH:
X$BH Column Name     GV$BH Column                     Name Meaning
ADDR                                 n/a                                     Buffer header address
INDX                                   n/a                                     Buffer header index (0-n)
INST_ID                              INST_ID                            Instance number, corresponds to GV$INSTANCE.INSTANCE_NUMBER
HLADDR                             n/a                                      Child latch address
BLSIZ                                  n/a                                      Block size
FLAG          DIRTY, TEMP, PING, STALE, DIRECT     Flag for the type and status of the block
TS#                                     TS#                                     Tablespace number; corresponds to V$TABLESPACE.TS#
FILE#                                  FILE#                                  File number; corresponds to V$DATAFILE.FILE#
DBARFIL                             n/a                                      Relative file number
DBABLK                             BLOCK#                              Block number from data block address                             
CLASS                                CLASS#                              Class number
STATE                                STATUS                              Block status (free, xcur, cr, etc.)
LE_ADDR              LOCK_ELEMENT_ADDR                Lock element address
OBJ                                    OBJD                                   Dictionary object number of the segment that contains the object
CR_SCN_BAS                    n/a                                       Consistent read SCN base
CR_SCN_WRP                   n/a                                       Consistent read SCN wrap
TCH                                     n/a                                       touch count
TIM                                      n/a                                        touch time

来自 “ ITPUB博客 ” ,链接:,如需转载,请注明出处,否则将追究法律责任。

上一篇: rman 备份(1)
下一篇: for 循环杀进程
请登录后发表评论 登录


  • 博文量
  • 访问量