Linux and Oracle questions

xmdms · 09-18-2008, 04:38 PM

Hi,

I am not sure if this is the forum for this question, but what the heck, I am a newbie anyway.

Here's my question; Would anyone know how to calculate the current Oracle database from the OS level if I do have the ASM disks info??

We have only one DBA onsite, but he's on vacation for 2 weeks.

Please help if you know the answer.

Thank you in advance.

J

immortaltechnique · 09-18-2008, 06:22 PM

Quote:

but what the heck, I am a newbie anyway

I think thats wrong, your profile clearly states that you are a "Member" with 101 posts...

I love pointing out the bleeding obvious.

Quote:

Would anyone know how to calculate the current Oracle database from the OS level

I could only assume you mean calculate the *size* of the database, right? What do you mean from OS level? Kindly tell us exactly what *it* is you want to accomplish.

Cheers, mate

yusufs · 09-18-2008, 06:34 PM

Quote:

Originally Posted by xmdms

Hi,

I am not sure if this is the forum for this question, but what the heck, I am a newbie anyway.

Here's my question; Would anyone know how to calculate the current Oracle database from the OS level if I do have the ASM disks info??

We have only one DBA onsite, but he's on vacation for 2 weeks.

Please help if you know the answer.

Thank you in advance.

J

Hai ,

if you want to know how many oracle database are running in that machine then use the command

ps -ef | grep pmon..

if you want to know about the listener ,use

ps -ef | grep tns

if you want to know the size of the database, which can be checked at oracle level using dba_data_files,dba_temp_files,v$controlfile,V$logfile. combine all this ,write a query and get the output..

is this what you want ?.. let us know

yusuf

chrism01 · 09-18-2008, 07:51 PM

From the OS level, you can look at the file sizes (the oracle conf file), but I don't think its poss to know how much free space you have (inside the DB) from there.
You'd have to use SQL for that.
You should be able to google up the SQL cmd for that.

immortaltechnique · 09-18-2008, 09:43 PM

Perhaps this is what you were refering to:
http://www.dbaexpert.com/blog/?p=124

Also as far as free-space is concerned this may assist you:

http://www.remote-dba.net/unix_linux/free_space.htm

Cheers

xmdms · 09-18-2008, 11:07 PM

Hi Guys,

I just need to know how big is our current Oracle DB on a particular environment. I would like to run some sort of a Linux command lines to find out how big it has grown since the last time I checked, etc.

I guess, I could do a 'df -h' on all the mount-points and try to figure it out from there I guess.

I thought, there might be an easier way to do this.

Thanks, guys!!

J