Linux and Oracle questions
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 |
Quote:
Quote:
Cheers, mate |
Quote:
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 |
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. |
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 |
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 |
All times are GMT -5. The time now is 06:43 AM. |