List out the views used to look at the size of a datafile, controlfiles, block size, determine free space in a tablespace ?

@ : Home > > Interview Room

- DBA_DATA_FILES or v$datafile view can be used to look at the size of a datafile .
- DBA_FREE_SPACE is used to determine free space in a tablespace.
- V$contolfile used to look at the size of a control file which includes maxlogfiles, maxlogmembers, maxinstances.
- Select * from v$controlfile gives the size of a controlfile.
- From SQL Plus, query show parameter block_size to get size of db_block_size.

Alert me