国外主机测评 - 国外VPS，国外服务器，国外云服务器，测评及优惠码
本站中文解释
ALL_LOB_SUBPARTITIONS视图是Oracle数据库中的系统视图，它存储着当前用户有权使用的LOB分区的信息。
这个视图的用途是提供当前用户有权使用的LOB分区的详细信息，包括：表中LOB分区名称、大小、子分区容量、分区描述等信息。
要使用这个视图，可以使用SELECT语句，如下所示：
SELECT * FROM ALL_LOB_SUBPARTITIONS;
这个语句将返回当前用户有权使用的所有LOB分区的详细信息。
官方英文解释
ALL_LOB_SUBPARTITIONS displays partition-level attributes of the LOB data subpartitions accessible to the current user.
Related Views
-
DBA_LOB_SUBPARTITIONSdisplays partition-level attributes of all LOB data subpartitions in the database. -
USER_LOB_SUBPARTITIONSdisplays the LOB subpartitions owned by the current user. This view does not display theTABLE_OWNERcolumn.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Owner of the table |
|
|
|
|
Name of the table |
|
|
|
Name of the LOB column |
|
|
|
|
|
Name of the partitioned LOB item |
|
|
|
Name of the LOB data partition to which this LOB data subpartition belongs |
|
|
|
|
Name of the table subpartition to which this LOB subpartition corresponds |
|
|
|
|
Name of the LOB subpartition |
|
|
|
|
Name of the corresponding LOB index subpartition |
|
|
|
|
Position of the LOB data partition within the LOB item |
|
|
|
|
Value of the |
|
|
|
|
|
Value of the |
|
|
|
Indicates whether and how the LOB data is to be cached in the buffer cache:
|
|
|
|
|
Indicates whether the |
|
|
|
|
|
Name of the tablespace containing the LOB data partition |
|
|
|
Size in bytes of the initial extent for the LOB data partition |
|
|
|
|
Size in bytes of secondary extents for the LOB data partition |
|
|
|
|
|
Minimum number of extents allowed in the segment of the LOB data partition |
|
|
|
|
Maximum number of extents allowed in the segment of the LOB data partition |
|
|
|
Maximum number of blocks allowed in the segment of the LOB data partition |
|
|
|
|
Retention option. Possible values for a SecureFiles segment:
Possible values for a BasicFiles segment:
|
|
|
|
|
Minimum retention duration for a SecureFiles segment |
|
|
|
|
Percentage increase in extent size for the LOB data partition |
|
|
|
|
Number of process freelists allocated in the segment of the LOB data partition |
|
|
|
|
Number of freelist groups allocated in the segment of the LOB data partition |
|
|
|
|
Indicates whether or not changes to the LOB are logged:
|
|
|
|
|
Buffer pool to be used for the LOB data partition blocks:
|
|
|
|
|
Database Smart Flash Cache hint to be used for subpartition blocks:
Solaris and Oracle Linux functionality only. |
|
|
|
|
Cell flash cache hint to be used for subpartition blocks:
See Also: Oracle Exadata Storage Server Software documentation for more information |
|
|
|
|
Indicates whether or not the LOB is encrypted. Possible values for SecureFiles:
Possible value for BasicFiles:
|
|
|
|
|
Level of compression used for this LOB. Possible values for SecureFiles:
Possible value for BasicFiles:
|
|
|
|
|
Kind of deduplication used for this LOB. Possible values for SecureFiles:
Possible value for BasicFiles:
|
|
|
|
|
Indicates whether the LOB is SecureFiles ( |
|
|
|
|
Indicates whether the LOB subpartition segment has been created ( |
|
|
|
|
|
Size of inline LOB storage (in bytes)
|
See Also:
-
“DBA_LOB_SUBPARTITIONS”
-
“USER_LOB_SUBPARTITIONS”
