关于free lists

segment header
 If the contention is on the segment header, then this is most likely free
list contention.
如果压力存在于segment的头部，那么这最可能是free list压力。

Automatic segment-space management in locally managed tablespaces eliminates the
need to specify the PCTUSED, FREELISTS, and FREELIST GROUPS parameters.

在本地管理表空间中的自动段管理机制革除了使用pctused 、FREELISTS,以及freelists  groups的需要。

If possible, switch from manual space management to automatic segment-space
management (ASSM).
如果可能，从手动空间管理切换到自动段空间管理(ASSM)

The following information is relevant if you are unable to use automatic
segment-space management (for example, because the tablespace uses dictionary
space management).

下面的信息是由价值的，如果你不能使用自动段管理来管理表空间。（比如说，表空间
使用字典表空间管理模式）

 

A free list is a list of free data blocks that usually includes blocks existing in a number
of different extents within the segment.

一个空白列表，是这样一个空闲数据块的列表，它一般包含在某一个segment里的
一系列extents中。

Free lists are composed of blocks in which free
space has not yet reached PCTFREE or used space has shrunk below PCTUSED.
Specify the number of process free lists with the FREELISTS parameter. The default
value of FREELISTS is one. The maximum value depends on the data block size.

空闲列表包含的数据块，里面的空闲空间还没达到PCTFREE ，或者使用的 空间已经减缩到
PCTUSED。使用FREELISTS参数 来指定一系列进程空闲列表。默认的FREELISTS 参数
数值是1。最大的数值要依据数据块的大小而定.

To find the current setting for free lists for that segment, run the following:
SELECT SEGMENT_NAME, FREELISTS
FROM DBA_SEGMENTS
WHERE SEGMENT_NAME = segment name
AND SEGMENT_TYPE = segment type;

查看某个segment里面的当前free lists设置，可以用下面的脚本，
SELECT SEGMENT_NAME, FREELISTS
FROM DBA_SEGMENTS
WHERE SEGMENT_NAME = segment name
AND SEGMENT_TYPE = segment type;

 

Set free lists, or increase the number of free lists. If adding more free lists does not
alleviate the problem, then use free list groups (even in single instance this can make a
difference). If using Oracle Real Application Clusters, then ensure that each instance
has its own free list group(s).

设置free lists，或者增加free lists的个数。如果增加更多的free lists 不能减轻问题，
那就使用free list 组（即使在单实例情况下也能有好的效果。如果使用oracle
RAC,那么请确认每个实例有自己的free lists 组。

 

See Also: Oracle Database Concepts for information on automatic
segment-space management, free lists, PCTFREE, and PCTUSED