Oracle 视图 DBA_SEGMENTS_OLD 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图DBA_SEGMENTS_OLD用于查询当前数据库中数据实例的所有存储段的属性信息。
它包含的信息有：存储段名称、创建存储段的用户的名称、存储段的大小以及所属的表空间等。
使用方法：
1. 通过dba_segments_old视图，SQL语句可以查询所有存储段的详细信息，如：
select segment_name,owner,bytes/1024/1024,tablespace_name from dba_segments_old;
2. 也可以使用dba_segments_old视图查询指定用户下的所有存储段信息，如：
select segment_name,bytes/1024/1024,tablespace_name from dba_segments_old where owner=’&LOWERSCHEMA’;
官方英文解释
DBA_SEGMENTS_OLD lists information about storage allocated for all database segments.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Username of the segment owner |
|
|
|
|
Name, if any, of the segment |
|
|
|
|
Name of the partition |
|
|
|
|
Type of segment: |
|
|
|
|
Name of the tablespace containing the segment |
|
|
|
|
ID of the file containing the segment header |
|
|
|
|
ID of the block containing the segment header |
|
|
|
|
Size, in bytes, of the segment |
|
|
|
|
Size, in Oracle blocks, of the segment |
|
|
|
|
Number of extents allocated to the segment |
|
|
|
|
Size in bytes requested for the initial extent of the segment at create time. (Oracle rounds the extent size to multiples of 5 blocks if the requested size is greater than 5 blocks.) |
|
|
|
|
Size in bytes of the next extent to be allocated to the segment |
|
|
|
|
Minimum number of extents allowed in the segment |
|
|
|
|
Maximum number of extents allowed in the segment |
|
|
|
|
Percent by which to increase the size of the next extent to be allocated |
|
|
|
|
Number of process freelists allocated to the segment |
|
|
|
|
Number of freelist groups allocated to this segment |
|
|
|
|
Relative file number of the segment header |
|
|
|
|
Buffer pool for the object |
