Re: Calculating space

From: Hardik <hvdesai_at_gmail.com>
Date: Thu, 17 Jul 2008 03:00:53 -0700 (PDT)
Message-ID: <3bc0d29f-29dc-4f94-9d53-945ba6e3f880@x41g2000hsb.googlegroups.com>


select sum(bytes)/1024/1024 from dba_segments where owner=<SCHEMA>;

On Jul 17, 4:27 am, ph3ng <jth..._at_gmail.com> wrote:
> 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 Thu Jul 17 2008 - 05:00:53 CDT

Original text of this message