了解Maclean Liu|向Maclean Liu提问 Oracle ALLSTARS 全明星(群内有多位Oracle高级售后support,N位OCM和ACE) QQ群 # QQ群号:23549328 # 已经升级到 2000人群,空位多多。欢迎有一定基础的Oracle骨友加入,现在入群需要经过Maclean的技术面试,欢迎面试,请加QQ号:47079569 为好友参加面试 2群基础群 适合刚入门的同学,会共享最佳入门实践和资料 QQ群 # QQ群号:171092051 # 已经升级到 500人的超级群,空位多多,无需面试

Buffer Lock Mode and Compatibilities

Buffer Modes:
  • KCBMNEW : New buffer for exclusive access
  • KCBMSHR : Current buffer for shared access
  • KCBMEXL : Current buffer for exclusive access
  • KCBMCR : CR buffer for shared access
  • KCBMCRX : Variant of CR mode
  • KCBMNULL : Used to keep a reference to the buffer
oracle_buffer_lock_compatibilities Buffer State
  • KCBBHFREE : buffer free
  • KCBBHEXLCUR : buffer current
  • KCBBHSHRCUR : buffer current
  • KCBBHCR : buffer consistent read
  • KCBBHREADING : being read
  • KCBBHMRECOVERY : media recovery
  • KCBBHIRECOVERY : crash or instance recovery
  • KCBBHWRITING : write clone
  • KCBBHPI : past image
  • KCBBHMEMORY : allocated memory buffer
  • KCBBHMWRITING : media recovery write clone
  • KCBBHDONATED : donated to another memory component
Buffer Class
  • KCBCDATA : DB blocks
  • KCBCSORT : sort blocks
  • KCBCSVUN : save undo blocks
  • KCBCSEGH : segment header blocks
  • KCBCSVSH : save undo segment hdrs
  • KCBCFRLS : free list blocks
  • KCBCEMAP : extent map
  • KCBCBMAP : bitmap block
  • KCBCIMAP : bitmap index block
  • KCBCBFSB : bitmapped file space bitmap
  • KCBCBFSH : bitmapped file space header
  • KCBCPW : prewarmed buffers class initially
 

posted on 2013-03-19 00:47  Oracle和MySQL  阅读(146)  评论(0编辑  收藏  举报

导航