LOB performance Guidelines
LOB performance GuidelinesContentsExecutive 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的操作,这个很陌生,可以学一下的 钱还是不够啊,有价值的东西贵啊 老大,这文档也太贵了吧!10个论坛币 收藏。。。 谢谢............... 先收藏,等有钱再买
页:
[1]