Oracle: DBA_TABLESPACES

select
   tbs.contents,                                                             -- PERMANENT, UNDO, TEMPORARY or LOST WRITE PROTECTION.
   tbs.tablespace_name,
   tbs.status,
   tbs.extent_management                                    ext_mgmt,
   tbs.allocation_type                                      ext_alloc_type,  -- How the size of new extents is determined SYSTEM: Oracle chooses size, UNIFORM: same size for all segments.
   tbs.segment_space_management                             seg_mgmt,        -- AUTO or MANUAL
   round(tbs.max_size * tbs.block_size / 1024/1024/1024, 2) max_size_gb,
   tbs.force_logging,   
   tbs.encrypted,  
   tbs.min_extents,  
   tbs.initial_extent,
   tbs.logging,  
   tbs.bigfile,
   tbs.block_size / 1024 bls_kb,
   tbs.chunk_tablespace,
   tbs.compress_for,
   tbs.def_cellmemory,
   tbs.def_index_compression,
   tbs.def_inmemory,
   tbs.def_inmemory_compression,
   tbs.def_inmemory_distribute,
   tbs.def_inmemory_duplicate,
   tbs.def_inmemory_priority,
   tbs.def_inmemory_service,
   tbs.def_inmemory_service_name,
   tbs.def_tab_compression,
   tbs.index_compress_for,
   tbs.lost_write_protect,
   tbs.max_extents,
   tbs.min_extlen,
   tbs.next_extent,
   tbs.pct_increase,
   tbs.plugged_in,
   tbs.predicate_evaluation,
   tbs.retention,
   tbs.shared
from
   sys.dba_tablespaces tbs
order by
   tbs.contents,
   tbs.tablespace_name;