Oracle help
in [Oracle Help]
|
Prev: paypal wholesale Christan Audigier shirt Coogi jeans(paypal accept)(www super- saler com
Next: Recovery fails with 06053 and 06025
From: ph3ng on 16 Jul 2008 22:14 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
From: Ana C. Dent on 16 Jul 2008 23:30 ph3ng <jthlcf(a)gmail.com> wrote in news:2655f5b4-cbfe-4527-b061-ff3807827281 @25g2000hsx.googlegroups.com: > > 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? 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)!
From: ph3ng on 16 Jul 2008 23:42 On Jul 17, 1:30 pm, "Ana C. Dent" <anaced...(a)hotmail.com> wrote: > ph3ng <jth...(a)gmail.com> wrote in news:2655f5b4-cbfe-4527-b061-ff3807827281 > @25g2000hsx.googlegroups.com: > > > > > 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? > > 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)! 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,
From: Ed Prochak on 17 Jul 2008 13:06
On Jul 16, 10:42 pm, ph3ng <jth...(a)gmail.com> wrote: > On Jul 17, 1:30 pm, "Ana C. Dent" <anaced...(a)hotmail.com> wrote: > > > ph3ng <jth...(a)gmail.com> wrote in news:2655f5b4-cbfe-4527-b061-ff3807827281 > > @25g2000hsx.googlegroups.com: > > > > 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? > > > 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)! > > 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, 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 |