Storage Viewer for Capacity Database Views > aps_v_database_datafiles
  
Version 10.0.01
aps_v_database_datafiles
The aps_v_database_datafiles view contains a single row for each database data file.
Table 4.10 aps_v_database_datafiles
Column Name
Data Type
Description
datafile_id
NUMBER
Foreign key to database data file details
db_instance_id
NUMBER
Foreign key to database instance details
db_instance_name
STRING
Database instance name
file_system_name
STRING
File system name
filesystem_id
NUMBER
Foreign key to filesystem details
free_size_gb
NUMBER
Free size in GiB
free_size_kb
NUMBER
Free size in KiB
increment_by_gb
NUMBER
Increment by GiB
increment_by_kb
NUMBER
Increment by KiB
increment_by_percent
NUMBER
Increment by percent
is_auto_extensible
CHAR
Y=Yes, N=No
last_updated
DATE
Last updated date
logical_name
STRING
Logical name
max_size_gb
NUMBER
Max size in GiB
max_size_kb
NUMBER
Max size in KiB
physical_name
STRING
Physical name
status
STRING
Status
tablespace_id
NUMBER
Foreign key to tablespace details
tablespace_name
STRING
Tablespace name
total_size_gb
NUMBER
Total size in GiB
total_size_kb
NUMBER
Total size in KiB