Re: Calculating space

On Jul 17, 6:00 am, Hardik <hvde..._at_gmail.com> wrote:
> 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- Hide quoted text -
>
> - Show quoted text -

For your total database storage usage you may also need to include the space used for sort which if a true temporary tablespace was defined will not be in dba_data_files. Loot at dba_temp_files.

HTH -- Mark D Powell -- Received on Thu Jul 17 2008 - 11:59:17 CDT