Oracle Query Table Space

1. View all tablespace usageSelectB.file_idFile ID number,
B.tablespace_name table space Name,
B.bytes/1024x768/1024x768||'M'Number of bytes,
(b.bytes-sum(NVL (A.bytes,0)))/1024x768/1024x768||'M'has been used,
       sum(NVL (A.bytes,0))/1024x768/1024x768||'M'Remaining space,
        - - sum(NVL (A.bytes,0))/(b.bytes)* -Occupancy percentage
        fromDba_free_space A,dba_data_files bwhereA.file_id=B.file_id Group  byB.tablespace_name,b.file_id, b.bytesOrder  byB.file_id;2. View the user's default tablespace.SelectUsername,default_tablespace fromdba_users;3. View the path and name of the data file used by the tablespace to be extendedSelect *  fromDba_data_fileswhereTablespace_name like 'users%';

Oracle Query Table Space