- You are here
- Comp Newsgroups Archived.At
- comp.databases.oracle.server
- 2008 July
- Calculating space

Subject: | Calculating space |

Posted by: | ph3ng (jthl…@gmail.com) |

Date: | Wed, 16 Jul 2008 |

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

- Re: Calculating space posted by Hardik on Thu, 17 Jul 2008
- Re: Calculating space posted by joel garry on Thu, 17 Jul 2008