Java SE (Java Platform, Standard Edition)

Just simply divide bytes by 1024/1024/1024:

SELECT a.TABLESPACE_NAME, 
Round(a.BYTES/1024/1024/1024,3) gigabytes_used, 
Round(b.BYTES/1024/1024/1024,3) gigabytes_free, 
Round(b.largest/1024/1024/1024,3), 
ROUND(((a.BYTES-b.BYTES)/a.BYTES)*100,2) percent_used 
FROM 
( 
SELECT TABLESPACE_NAME, 
SUM(BYTES) BYTES 
FROM dba_data_files 
GROUP BY TABLESPACE_NAME 
) 
a, 
( 
SELECT TABLESPACE_NAME, 
SUM(BYTES) BYTES , 
MAX(BYTES) largest 
FROM dba_free_space 
GROUP BY TABLESPACE_NAME 
) 
b 
WHERE a.TABLESPACE_NAME=b.TABLESPACE_NAME 
ORDER BY ((a.BYTES-b.BYTES)/a.BYTES) DESC;

1 gigabyte = 1024 ^3 bytes = 1 073 741 824 bytes

so -
a.bytes bytes_used
can become
a.bytes/1073741824 gigabytes_used

In storage, it is common sense to say 1GB = 1e6 bytes

http://wapedia.mobi/en/Giga

I first thought it was a marketing trick to sale 0.976 Gibibytes to the price of 1G, but it seems hard disk vendors always preferred decimal systems.

Or even more common sense to say 1GB = 1e9 bytes ;-)

Regards,
Rob.

Hi,

Instead of saying

x / 1024 / 1024 / 1024

you can say

x / POWER (2, 30)

or

x / POWER (1024, 3)

I define a substitution variable in my LOGIN.SQL file.

So if I have 1GB table on disk, it actually takes slightly less than 1GB of memory once I read it into SGA?

Just for fun, if this were PL/SQL instead of SQL, you could also use

1024**3

or even

2**30

@user619226:

{noformat}>{noformat} HOW DO I MAKE IT TO see in Gigabytes?

Look up "Gigabyte" in a dictionary and divide the bytes figure by that number? Apologies if I am missing something.