Determine the total disk space for a user


SELECT  sum(bytes)/power(1024, 0) BYTES, sum(bytes)/power(1024, 1) KB, 
sum(bytes)/power(1024, 2) MB, sum(bytes)/power(1024, 3) GIGA, 
sum(bytes)/power(1024, 4) TERA
FROM DBA_DATA_FILES d 
WHERE d.tablespace_name in 
(select distinct tablespace_name from  dba_segments  Where OWNER = upper('&username'));

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: