Dba_data_files:
File_name data file name and path
File_id data file ID
Bytes data file size
Number of database blocks corresponding to the bocks data file size
Tablespace_name the tablespace name corresponding to the data file
Can autoextensible database files be automatically expanded?
Maxbytes
Maxblocks the maximum number of bytes and the number of data blocks that can be expanded for this file.
User_bytes
User_blocks indicates the size of data files that can be used by the user, which is equal to the space used by datafile size-LMT/DMT.
# Attributes for auto scaling
Alter tablespace...
Datafile '... 'size...
Autoextent on
Next...
Maxsize...
# LML (local management tablespace)
Alter tablespace...
Datafile '... 'size...
Extent management local autoallocate/uniform size ...;
# DML (dictionary management tablespace)
Create tablespace...
Datafile '... 'size...
Extent management dictionary
Blocksize...
Default storage (initial
Next
Minextents
Maxextents
Pctincrease)
V $ datafile: describes the synchronization information of data files.
Dba_free_space:
Bytes, blocks indicates the free space size and number of partitions in the tablespace.
V $ filestat:
Phyrds, phywrts indicates the database read and written by the physical disk