Human Readable at Oracle with dbms_xplan Functions

Format numbers with using dbms_xplan.

• FORMAT_SIZE
• FORMAT_SIZE2
• FORMAT_NUMBER
• FORMAT_NUMBER2

select bytes, bytes/1024/1024, dbms_xplan.FORMAT_SIZE(bytes),dbms_xplan.FORMAT_SIZE2(bytes),dbms_xplan.FORMAT_NUMBER(bytes),dbms_xplan.FORMAT_NUMBER2(bytes) bytes from v$datafile;

Database Size Calculation Example

select 'Database Size:  '||dbms_xplan.FORMAT_NUMBER(sum(bytes)) from v$datafile;