find storage of tables oracle code example

Example: plsql check how much space all databases are consuming

# To get how much bytes all data files are consuming in Oracle, run this
select sum(bytes) from dba_data_files;

# after that google how many mb, gb, tb, pb etc... that many bytes are