LOB performance Guidelines

Maclean Liu(刘相兵

LOB performance Guidelines

ContentsExecutive Overview
  LOB Overview
  Important Storage Parameters
  CHUNK
  Definition
  Points to Note
  Recommendation
  In-line and Out-of-Line storage: ENABLE STORAGE IN ROW and DISABLE STORAGE IN ROW4
  Definition
  Points to Note
  Recommendation
  CACHE, NOCACHE
  Definition
  Points to Note
  Recommendation
  Consistent Reads on LOBs: RETENTION and PCTVERSION
  Definition
  Points to Note
  Recommendation
  LOGGING, NOLOGGING
  Definition
  Points to Note
  Recommendation
  Performance GUIDELINE - LOB Loading
  Points to Note
  Use array operations for LOB inserts
  APPENDIX A
  LONG API access to LOB datatype
  APPENDIX B
  Migration from in-line to out-of-line (and out-of-line to in-line) storage
  APPENDIX C
  How LOB data is stored
  In-line LOB - LOB size   less than 3964 bytes
  In-line LOB - LOB size   = 3965 bytes (1 byte greater than 3964)
  In-line LOB - LOB size   greater than 12 chunk addresses


lob_performance_guidelines.pdf (202.64 KB, 下载次数: 23, 售价: 10 金钱)

2012-4-20 21:34 上传

点击文件名下载附件
售价: 10 金钱  [记录]

zhuqibs

lob的操作，这个很陌生，可以学一下的

zhuqibs

钱还是不够啊，有价值的东西贵啊

kelvin_lok

老大，这文档也太贵了吧！10个论坛币

ziyoo0830

收藏。。。

望月飞鱼

谢谢...............

justinleisure

先收藏，等有钱再买