[repost]Oracle RDBMS : Generic Large Object (LOB) Performance Guidelines

作者: Maclean Liu, post on September 11th, 2011

Oracle的Giri Mandalika给我们介绍了LOB大型对象的一些调优注意事项，之前我一直对_shared_io_pool_size这个undocumented参数不甚了解，以为它是一个shared pool相关的参数，根本原因是甚至没有任何一个公开的Mos Note介绍了这几个隐藏参数。

而这篇文章给出了比较好的解释，这里引用一下：

This blog post is generic in nature and based on my recent experience with a content management system where securefile BLOBs are critical in storing and retrieving the checked in content. It is stro ngly suggested to check the official documentation in addition to these brief guidelines. In general, Oracle . . . → Read More: [repost]Oracle RDBMS:Generic Large Object (LOB) Performance Guidelines

Leave a comment   Oracle, Oracle LOB大对象   , , , , ,  

Troubleshooting Guide (TSG) – Large Objects (LOBs)

作者: Maclean Liu, post on September 23rd, 2009

Applies to:

Oracle Server – Enterprise Edition – Version: 8.0.3.0 to 11.1.0.7 – Release: 8.0.3 to 11.1 Information in this document applies to any platform.

Purpose

This is the troubleshooting guide for handling Large Objects (LOBs) within Oracle Support and is part of the Enhanced Problem Analysis (EPA) project.

The purpose of this document is . . . → Read More: Troubleshooting Guide (TSG) – Large Objects (LOBs)

Leave a comment   Oracle, Oracle LOB大对象   , , ,  

CLOBs and NCLOBs character set storage in Oracle Release 8i, 9i, 10g and 11g

作者: Maclean Liu, post on March 30th, 2009

Applies to:

Oracle Server – Enterprise Edition – Version: 8.0.3.0 to 11.2.0.2 Information in this document applies to any platform.

Purpose

CLOBs when using fixed width character set NLS_CHARACTERSET are stored in the NLS_CHARACTERSET character set on disk. Examples are WE8MSWIN1252 , AR8ISO8859P6 etc.

However , CLOB’s (and NCLOB’s) of varying-width character sets (ex: UTF8, . . . → Read More: CLOBs and NCLOBs character set storage in Oracle Release 8i, 9i, 10g and 11g

Leave a comment   Oracle, Oracle LOB大对象   , , , , ,