Oracle help

From: ph3ng <jthlcf_at_gmail.com>
Date: Wed, 16 Jul 2008 19:14:57 -0700 (PDT)
Message-ID: <2655f5b4-cbfe-4527-b061-ff3807827281@25g2000hsx.googlegroups.com>


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 Received on Wed Jul 16 2008 - 21:14:57 CDT

Original text of this message