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

ph3ng <jthlcf (AT) gmail (DOT) com> wrote in news:2655f5b4-cbfe-4527-b061-ff3807827281
@25g2000hsx.googlegroups.com:
1) You don't get the answer by using SQL.
2) You ask the Operating System (OS) the right question.

Since you decided we did not need to know your OS,
You're On Your Own (YOYO)!

ph3ng <jthlcf (AT) gmail (DOT) com> wrote in news:2655f5b4-cbfe-4527-b061-ff3807827281
@25g2000hsx.googlegroups.com:
1) You don't get the answer by using SQL.
2) You ask the Operating System (OS) the right question.

Since you decided we did not need to know your OS,
You're On Your Own (YOYO)!

ph3ng <jthlcf (AT) gmail (DOT) com> wrote in news:2655f5b4-cbfe-4527-b061-ff3807827281
@25g2000hsx.googlegroups.com:
1) You don't get the answer by using SQL.
2) You ask the Operating System (OS) the right question.

Since you decided we did not need to know your OS,
You're On Your Own (YOYO)!

ph3ng <jthlcf (AT) gmail (DOT) com> wrote in news:2655f5b4-cbfe-4527-b061-ff3807827281
@25g2000hsx.googlegroups.com:
1) You don't get the answer by using SQL.
2) You ask the Operating System (OS) the right question.

Since you decided we did not need to know your OS,
You're On Your Own (YOYO)!

On Jul 17, 1:30*pm, "Ana C. Dent" <anaced... (AT) hotmail (DOT) com> wrote:
Thanks for the response. Hmmmmm perhaps I should rephrase or I am not
asking the right things - still new as such dba jargons are fairly new
to me. Please excuse me for that.

1) When you say ask the OS, could you elaborate more? And how would I
be asking?

Thanks,

On Jul 17, 1:30*pm, "Ana C. Dent" <anaced... (AT) hotmail (DOT) com> wrote:
Thanks for the response. Hmmmmm perhaps I should rephrase or I am not
asking the right things - still new as such dba jargons are fairly new
to me. Please excuse me for that.

1) When you say ask the OS, could you elaborate more? And how would I
be asking?

Thanks,

On Jul 17, 1:30*pm, "Ana C. Dent" <anaced... (AT) hotmail (DOT) com> wrote:
Thanks for the response. Hmmmmm perhaps I should rephrase or I am not
asking the right things - still new as such dba jargons are fairly new
to me. Please excuse me for that.

1) When you say ask the OS, could you elaborate more? And how would I
be asking?

Thanks,

On Jul 17, 1:30*pm, "Ana C. Dent" <anaced... (AT) hotmail (DOT) com> wrote:
Thanks for the response. Hmmmmm perhaps I should rephrase or I am not
asking the right things - still new as such dba jargons are fairly new
to me. Please excuse me for that.

1) When you say ask the OS, could you elaborate more? And how would I
be asking?

Thanks,

On Jul 16, 10:42 pm, ph3ng <jth... (AT) gmail (DOT) com> wrote:
OS -> Operating System
It is not DBA jargon. It is not database jargon. but it is computer
jargon.

Either English is not your primary language or you are presenting
yourself as an example of the Peter Principle.

Assuming language is the issue:
you find the directory where the database files are stored and you
check the sizes. In LINUX it might be
cd $ORACLE_HOME/u01
ls -l

HTH,
Ed