DBABD

Information About the Data Files (Oracle) | #masterdata | Component: CCMS / Database Monitors for Oracle
Column Name Description
SYS_ID Database system ID
OPER_ID Unique operation ID
TASKNAME Task Name
JOB_NR Unique Job Number in a Task
TRIAL Unique ID Number of the Suboperation
UTIL_NR Utility number within job step
FUNC_ID DBA Function ID
REC_NR Unique record number for file
Column Name Description
Column Name Description
Column Name Description
Column Name Description
TSP_STATUS Tablespace status Show values
DBF_STATUS Data file status Show values
Column Name Description Domain name
UPD_OP Update Time Stamp SDBA_UPD
DBF_ID File ID (Oracle) CHAR4
TSP_NAME Tablespace name SDBA_TSP
TIME_BEG Data file backup start time SDBA_TSTMP
TIME_END End of data file backup SDBA_TSTMP
REDO_BEG Redo log number at start of data file backup CHAR8
REDO_END Redo log number at end of data file backup CHAR8
VOLUME Name of backup volume CHAR10
FILE_POS Position of file on storage device NUMC4
COMP_RATE Compression rate CHAR10
UTIL_BID SID of a backup file (using external backup program) CHAR16
FILE_NAME Complete path including file name CHAR255
FILE_SIZE File size CHAR12
INTERNAL For internal purposes CHAR255