oracle dba_data_files视图字段说明

时间:2021-06-10 14:55:31
 table DBA_DATA_FILES is 'Information about database data files';

 表DBA_DATA_FILES是数据库数据文件信息表;

column DBA_DATA_FILES.FILE_NAME is 'Name of the database data file';

DBA_DATA_FILES.FILE_NAME是数据库数据文件的名字,也是物理文件存放地址;

column DBA_DATA_FILES.FILE_ID is 'ID of the database data file';

DBA_DATA_FILES.FILE_ID 是数据库文件的ID;

column DBA_DATA_FILES.TABLESPACE_NAME is 'Name of the tablespace to which the file belongs';

DBA_DATA_FILES.TABLESPACE_NAME 是所属表空间的名字;

column DBA_DATA_FILES.BYTES is 'Size of the file in bytes';

DBA_DATA_FILES.BYTES是文件的大小,以bytes为单位;

column DBA_DATA_FILES.BLOCKS is 'Size of the file in ORACLE blocks';

DBA_DATA_FILES.BLOCKS是ORACLE文件的大小;

column DBA_DATA_FILES.STATUS is 'File status:  "INVALID" or "AVAILABLE"';

DBA_DATA_FILES.STATUS是文件的状态:“无效”或者“有效”;

column DBA_DATA_FILES.RELATIVE_FNO is 'Tablespace-relative file number';

column DBA_DATA_FILES.RELATIVE_FNO是表空间相对文件号;

column DBA_DATA_FILES.AUTOEXTENSIBLE is 'Autoextensible indicator:  "YES" or "NO"';

DBA_DATA_FILES.AUTOEXTENSIBLE是否自动扩展;

column DBA_DATA_FILES.MAXBYTES is 'Maximum size of the file in bytes';

DBA_DATA_FILES.MAXBYTES是文件的最大多少byte;

column DBA_DATA_FILES.MAXBLOCKS is 'Maximum size of the file in ORACLE blocks';

DBA_DATA_FILES.MAXBLOCKS是ORACLE文件的最大数;

column DBA_DATA_FILES.INCREMENT_BY is 'Default increment for autoextension';

DBA_DATA_FILES.INCREMENT_BY默认自动增量值;

column DBA_DATA_FILES.USER_BYTES is 'Size of the useful portion of file in bytes';

DBA_DATA_FILES.USER_BYTES是指文件中有用的大小;

column DBA_DATA_FILES.USER_BLOCKS is 'Size of the useful portion of file in ORACLE blocks';

DBA_DATA_FILES.USER_BLOCKS是指ORACLE文件有用的大小;

column DBA_DATA_FILES.ONLINE_STATUS is 'Online status of the file';

DBA_DATA_FILES.ONLINE_STATUS是文件的在线状态;