LinuxQuestions.org
Visit Jeremy's Blog.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 09-18-2008, 05:38 PM   #1
xmdms
Member
 
Registered: Oct 2003
Posts: 134

Rep: Reputation: 15
Question 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
 
Old 09-18-2008, 07:22 PM   #2
immortaltechnique
Member
 
Registered: Oct 2006
Location: Kenya
Distribution: Ubuntu, RHEL, OpenBSD
Posts: 287

Rep: Reputation: 32
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
 
Old 09-18-2008, 07:34 PM   #3
yusufs
Member
 
Registered: Oct 2007
Posts: 162

Rep: Reputation: 30
Quote:
Originally Posted by xmdms View Post
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
 
Old 09-18-2008, 08:51 PM   #4
chrism01
LQ Guru
 
Registered: Aug 2004
Location: Sydney
Distribution: Centos 6.8, Centos 5.10
Posts: 17,240

Rep: Reputation: 2324Reputation: 2324Reputation: 2324Reputation: 2324Reputation: 2324Reputation: 2324Reputation: 2324Reputation: 2324Reputation: 2324Reputation: 2324Reputation: 2324
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.
 
Old 09-18-2008, 10:43 PM   #5
immortaltechnique
Member
 
Registered: Oct 2006
Location: Kenya
Distribution: Ubuntu, RHEL, OpenBSD
Posts: 287

Rep: Reputation: 32
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
 
Old 09-19-2008, 12:07 AM   #6
xmdms
Member
 
Registered: Oct 2003
Posts: 134

Original Poster
Rep: Reputation: 15
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
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] basic oracle / database questions ?? vikas027 Linux - General 15 09-04-2008 09:40 AM
LXer: Oracle and Symantec Certify Veritas Data Center Solutions on Oracle(R) Enterprise Linux LXer Syndicated Linux News 0 07-18-2007 07:31 AM
LXer: Oracle(R) Database Standard Edition One and Oracle Enterprise Linux on HP Set New World Record for Price Performance with TPC-C Benchmark LXer Syndicated Linux News 0 06-12-2007 06:01 PM
RHEL AS/ES 4 installation for oracle 10g DB and/or AS questions kuman2k Linux - Enterprise 2 01-25-2007 06:31 AM
LXer: Oracle Enhances Oracle Validated Configurations With More Solutions and New Partners to Help Deploy Linux Faster LXer Syndicated Linux News 0 08-16-2006 07:54 PM


All times are GMT -5. The time now is 03:14 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration