CODE EXAMPLE FOR SQL

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