Search notes:

Oracle: DBA_FREE_SPACE

select
   frs.tablespace_name,
   to_char(frs.block_id * tbs.block_size /1024/1024 , '999,999.00') start_mb,
   to_char(frs.bytes                     /1024/1024,     '999.00') length_mb,
   fil.file_name
-- frs.file_id
-- tbs.block_size
from
   dba_free_space   frs                                              join
   dba_data_files   fil on frs.file_id         = fil.file_id         join
   dba_tablespaces  tbs on frs.tablespace_name = tbs.tablespace_name
order by
   frs.tablespace_name,
   frs.block_id;
Github repository Oracle-Patterns, path: /Installed/data-dictionary/free_space/joins.sql

See also

dba_free_space_coalesced (which shows one record per tablespace), dba_dmt_free_space, dba_temp_free_space
data dictionary

Index

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1741096798, '52.14.78.246', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/installed/data-dictionary/free_space/index(54): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78