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>
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