Calculating space

Giganews Newsgroups
Subject: Calculating space
Posted by:  ph3ng (jthl…@gmail.com)
Date: Wed, 16 Jul 2008

Hello

I am a junior dba. I was wondering if anyone could point me how to do
the following?:

I am currently trying to verify/calculate the size of my current
oracle db/schema. I've been using:

select sum(bytes)/1024/1024 from dba_data_files + select sum(bytes)/
1024/1024 from v$log;

(NOTE: I ran the two select statements separately. Just thought I'd
clarify)

Now I'd like to be able to know the size of the actual storage/disk
for where that particular schema is sitting on. Is this possible? If
so how would I be doing this, what is the syntax?

Thank you

Replies