DBA_LOB_PARTITIONS displays all LOB partitions in the database. Its columns are the same as those in "ALL_LOB_PARTITIONS".
· ALL_LOB_PARTITIONS displays LOB partitions contained in tables accessible to the current user.
· USER_LOB_PARTITIONS describes the LOB partitions owned by the current user. This view does not display the TABLE_OWNER column.
| 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 table partition |
|
|
| | Name of the LOB data partition |
|
|
| | Name of the corresponding LOB index partition |
|
|
| | Position of the LOB data partition within the LOB item |
|
|
| | Whether the partition is composite ( |
|
|
| | Value of the |
|
|
| | Value of the |
|
|
| | Whether and how the cluster is to be cached in the buffer cache ( |
|
|
| | Whether the |
|
|
| | Name of the tablespace containing the LOB data partition |
|
|
| | Size in bytes of the initial extent of the LOB data partition |
|
|
| | Size in bytes of secondary extents of 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 |
|
|
| | 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 |
|
|
| | Logging attribute of the LOB data partition |
|
|
| | Default buffer pool for the LOB partition blocks |
|
|
| | Whether or not the LOB is encrypted |
|
|
| | The level of compression used for this LOB |
|
|
| | The kind of deduplication used for this LOB |
|
|
| | Indicates whether the LOB is a SecureFile LOB ( |
Note:
1. check LOB partition in the database:
select table_owner, table_name, column_name, lob_name, partition_name,
lob_partition_name, tablespace_name, buffer_pool
from DBA_LOB_PARTITIONS;
| TABLE_ OWNER | TABLE_NAME | COLUMN_ NAME | LOB_NAME | PARTITION_ NAME | LOB_ PARTITION_ NAME | TABLESPACE_ NAME | BUFFER_ POOL |
| SYS | STREAMS$_APPLY_ SPILL_MSGS_PART | MESSAGE | SYS_LOB0001008458C00008$$ | P0 | SYS_LOB_P1 | SYSAUX | DEFAULT |
Oracle data dictionary views
Oracle dynamic performance views
No comments:
Post a Comment