Calculating space
From: ph3ng <jthlcf_at_gmail.com>
Date: Wed, 16 Jul 2008 20:27:56 -0700 (PDT)
Message-ID: <318300ac-4e49-44f0-b1d0-1ea8f2b94a25@s50g2000hsb.googlegroups.com>
Date: Wed, 16 Jul 2008 20:27:56 -0700 (PDT)
Message-ID: <318300ac-4e49-44f0-b1d0-1ea8f2b94a25@s50g2000hsb.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 - 22:27:56 CDT