temp file monitoring sql query

Monitor temporary table space in oracle

SQL>set lines 100
      select TABLESPACE_NAME,floor(TABLESPACE_SIZE/ 1024 / 1024) "size MB",       floor(ALLOCATED_SPACE / 1024 / 1024)  "user MB",
      ceil(FREE_SPACE*100/ALLOCATED_SPACE)||'%' usd_spce_per from dba_temp_free_space;

TABLESPACE_NAME                   size MB    user MB USD_SPCE_PER
------------------------------         ----------    ---------- -----------------------------------------
TEMP                                                    54         54                99%

TABLESPACE_NAME: shows table space name.
size mb: show the total table space size.
user mb: shows the Total allocated space, in bytes, including space that is currently allocated and used     and  space that is currently allocated and available for reuse
USD_SPCE_PER: free space available in percentage