rac sga cache_buffer_size "V$BH"
来源:互联网 发布:欧弟老婆开的淘宝店铺 编辑:程序博客网 时间:2024/05/11 05:27
V$BH:This is a Real Application Clusters view. This view gives the status and number of pings for every buffer in the SGA.
--记录了sga缓冲区中的object及其状态
FILE#
NUMBER
Datafile identifier number (to find the filename, queryDBA_DATA_FILES
or V$DBFILE
)BLOCK#
NUMBER
Block numberCLASS#
NUMBER
Class numberSTATUS
VARCHAR2(6)
Status of the buffer:free
- Not currently in usexcur
- Exclusivescur
- Shared currentcr
- Consistent readread
- Being read from diskmrec
- In media recovery modeirec
- In instance recovery mode
XNC
NUMBER
Number of PCM x to null lock conversions due to contention with another instance. This column is obsolete and maintained for backward compatibility.LOCK_ELEMENT_ADDR
RAW(4 | 8)
Address of the lock element that contains the PCM lock that is covering the buffer. If more than one buffer has the same address, then these buffers are covered by the same PCM lock.LOCK_ELEMENT_NAME
NUMBER
The address of the lock element that contains the PCM lock that is covering the buffer. If more than one buffer has the same address, then these buffers are covered by the same PCM lock.LOCK_ELEMENT_CLASS
NUMBER
The address of the lock element that contains the PCM lock that is covering the buffer. If more than one buffer has the same address, then these buffers are covered by the same PCM lock.FORCED_READS
NUMBER
Number of times the block had to be reread from the cache because another instance has forced it out of this instance's cache by requesting the lock on the block in exclusive modeFORCED_WRITES
NUMBER
Number of times GCS had to write this block to cache because this instance had used the block and another instance had requested the lock on the block in a conflicting modeDIRTY
VARCHAR2(1)
Y
- block modifiedTEMP
VARCHAR2(1)
Y
- temporary blockPING
VARCHAR2(1)
Y
- block pingedSTALE
VARCHAR2(1)
Y
- block is staleDIRECT
VARCHAR2(1)
Y
- direct blockNEW
VARCHAR2(1)
Always set to N
. This column is obsolete and maintained for backward compatibility.OBJD
NUMBER
Database object number of the block that the buffer representsTS#
NUMBER
Tablespace number of blockSQL> select sum(BLOCK#),status from v$bh group by status;
SUM(BLOCK#) STATUS
----------- ---------------------
1.0537E+11 xcur
1.1988E+10 cr
SQL> alter system flush buffer_cache;
System altered.
SQL> select sum(BLOCK#),status from v$bh group by status;
SUM(BLOCK#) STATUS
----------- ---------------------
854666 xcur
1.1735E+11 free
- rac sga cache_buffer_size "V$BH"
- v$BH解释
- v$sga;
- X$BH及V$BH中各字段意义
- X$BH及V$BH中各字段意义
- v$sga/v$sgainfo/v$sgastat
- Oracle 10g: v$SGA
- 通过案例学调优之--动态视图(v$bh和x$bh)
- 通过案例学调优之--动态视图(v$bh和x$bh)
- 关于 v$waitstat 和 x$bh.class 的关系
- 怎样将V$LATCH_CHILDREN、X$BH、DBA_EXTENTS三张表关联起来
- 关于 v$waitstat 和 x$bh.class 的关系
- 用V$BH查看表查看数据缓冲区
- 关于 v$waitstat 和 x$bh.class 的关系
- RAC下修改SGA的实战操作
- RAC下修改SGA的实战操作
- oracle 10g RAC修改sga
- RAC环境下修改SGA参数(转)
- LIBRARY_PATH和LD_LIBRARY_PATH环境变量的区别
- SSH登录拦截器1
- 第九次上机实验
- Spring Data操作Redis时,发现key值出现 \xac\xed\x00\x05t\x00\tb
- 迭代器(Iterator)
- rac sga cache_buffer_size "V$BH"
- Android Audio System 之一:AudioTrack如何与AudioFlinger交换音频数据
- 别人女人讲理
- vim代码折叠
- 算法导论8.3-4 O(n)时间内对[0..n^-1]之间的n个数排序
- Create A Form
- 【Google官方教程】第三课:缓存Bitmap
- oracle 时间模型
- android完美的退出方法