Oracle 视图 ALL_LOB_PARTITIONS 官方解释，作用，如何使用详细说明

本站中文解释

ALL_LOB_PARTITIONS视图可显示出具有大对象（LOB）属性的分区的信息。它会显示拥有SEGMENT_NAME， SEGMENT_TYPE，COMPRESSION，LOGGING，CACHE， RETENTION，PCTVERSION，TBLSPACE_NAME，PARTITION_NAME及PARTITION_POSITION字段。

使用ALL_LOB_PARTITIONS视图可以获得存储在分区表中的大对象（LOB）属性的信息。

要使用ALL_LOB_PARTITIONS视图，需要调用它的SELECT语句。比如：

SELECT * FROM ALL_LOB_PARTITIONS;

该查询语句将会返回存储在分区表中的大对象（LOB）属性的所有信息。

官方英文解释

ALL_LOB_PARTITIONS displays the LOB partitions in the tables accessible to the current user.

Related Views

DBA_LOB_PARTITIONS displays all LOB partitions in the database.
USER_LOB_PARTITIONS displays the LOB partitions owned by the current user. This view does not display the TABLE_OWNER column.

Column	Datatype	Description
`TABLE_OWNER`	`VARCHAR2(128)`	Owner of the table
`TABLE_NAME`	`VARCHAR2(128)`	Name of the table
`COLUMN_NAME`	`VARCHAR2(4000)`	Name of the LOB column
`LOB_NAME`	`VARCHAR2(128)`	Name of the partitioned LOB item
`PARTITION_NAME`	`VARCHAR2(128)`	Name of the table partition
`LOB_PARTITION_NAME`	`VARCHAR2(128)`	Name of the LOB data partition
`LOB_INDPART_NAME`	`VARCHAR2(128)`	Name of the corresponding LOB index partition
`PARTITION_POSITION`	`NUMBER`	Position of the LOB data partition within the LOB item
`COMPOSITE`	`VARCHAR2(3)`	Indicates whether the partition is composite (`YES`) or not (`NO`)
`CHUNK`	`NUMBER`	Value of the `CHUNK` attribute of the LOB data partition
`PCTVERSION`	`NUMBER`	Value of the `PCTVERSION` attribute of the LOB data partition
`CACHE`	`VARCHAR2(10)`	Indicates whether and how the LOB data is to be cached in the buffer cache: `YES` – LOB data is placed in the buffer cache `NO` – LOB data either is not brought into the buffer cache or is brought into the buffer cache and placed at the least recently used end of the LRU list `CACHEREADS` – LOB data is brought into the buffer cache only during read operations but not during write operations
`IN_ROW`	`VARCHAR2(3)`	Indicates whether the `STORAGE IN ROW` attribute is enabled for the LOB data partition (`YES`) or not (`NO`)
`TABLESPACE_NAME`	`VARCHAR2(30)`	Name of the tablespace containing the LOB data partition
`INITIAL_EXTENT`	`VARCHAR2(40)`	Size (in bytes) of the initial extent of the LOB data partition, or `DEFAULT`
`NEXT_EXTENT`	`VARCHAR2(40)`	Size (in bytes) of secondary extents of the LOB data partition, or `DEFAULT`
`MIN_EXTENTS`	`VARCHAR2(40)`	Minimum number of extents allowed in the segment of the LOB data partition, or `DEFAULT`
`MAX_EXTENTS`	`VARCHAR2(40)`	Maximum number of extents allowed in the segment of the LOB data partition, or `DEFAULT`
`MAX_SIZE`	`VARCHAR2(40)`	Maximum number of blocks allowed in the segment of the LOB data partition, or `DEFAULT`
`RETENTION`	`VARCHAR2(7)`	Retention option. Possible values for a SecureFiles segment: `NONE` `AUTO` `MIN` `MAX` `DEFAULT` `INVALID` Possible values for a BasicFiles segment: `YES` `NO`
`MINRETENTION`	`VARCHAR2(40)`	Minimum retention duration for a SecureFiles segment, or `DEFAULT`
`PCT_INCREASE`	`VARCHAR2(40)`	Percentage increase in extent size for the LOB data partition, or `DEFAULT`
`FREELISTS`	`VARCHAR2(40)`	Number of process freelists allocated in the segment of the LOB data partition, or `DEFAULT`
`FREELIST_GROUPS`	`VARCHAR2(40)`	Number of freelist groups allocated in the segment of the LOB data partition, or `DEFAULT`
`LOGGING`	`VARCHAR2(7)`	Indicates whether or not changes to the LOB are logged: `NONE` – Not specified See Also: the `*_LOB_SUBPARTITIONS` view `YES` `NO`
`BUFFER_POOL`	`VARCHAR2(7)`	Buffer pool for the LOB partition blocks: `DEFAULT` `KEEP` `RECYCLE` NULL
`FLASH_CACHE`	`VARCHAR2(7)`	Database Smart Flash Cache hint to be used for partition blocks: `DEFAULT` `KEEP` `NONE` Solaris and Oracle Linux functionality only.
`CELL_FLASH_CACHE`	`VARCHAR2(7)`	Cell flash cache hint to be used for partition blocks: `DEFAULT` `KEEP` `NONE` See Also: Oracle Exadata Storage Server Software documentation for more information
`ENCRYPT`	`VARCHAR2(4)`	Indicates whether or not the LOB is encrypted. Possible values for SecureFiles: `YES` `NO` Possible value for BasicFiles: `NONE` – Not applicable
`COMPRESSION`	`VARCHAR2(6)`	Level of compression used for this LOB. Possible values for SecureFiles: `LOW` `MEDIUM` `HIGH` `NO` – Compression is off Possible value for BasicFiles: `NONE` – Not applicable
`DEDUPLICATION`	`VARCHAR2(15)`	Kind of deduplication used for this LOB. Possible values for SecureFiles: `LOB` – Deduplicate `NO` – Keep duplicates Possible value for BasicFiles: `NONE` – Not applicable
`SECUREFILE`	`VARCHAR2(3)`	Indicates whether the LOB is SecureFiles (`YES`) or not (`NO`)
`SEGMENT_CREATED`	`VARCHAR2(3)`	Indicates whether the LOB partition segment has been created (`YES`) or not (`NO`); `N/A` indicates that this LOB is subpartitioned and no segment exists at the partition level
`MAX_INLINE`	`NUMBER`	Size of inline LOB storage (in bytes) For inline LOBs (`IN_ROW` `=` `YES`), this column displays the size of inline LOB storage (in bytes). For out-of-inline LOBs (`IN_ROW` `=` `NO`), the value of this column is `0`. For LOBs in subpartitioned tables, the value of this column is null. Instead, refer to the `MAX_INLINE` column in the `*_LOB_SUBPARTITIONS` views.