Re: OS Information from Database

We have cron job that does 'df -k' to a flat-file every hour or so (this can be tweaked). 

That file can then be read as an external table and you can join to other dba_% views

-Deepak




________________________________
From: "SHEEHAN, JEREMY" <JEREMY.SHEEHAN_at_fpl.com>
To: "mark.powell_at_eds.com" <mark.powell_at_eds.com>; oracle list <oracle-l_at_freelists.org>
Sent: Monday, February 23, 2009 2:35:48 PM
Subject: RE: OS Information from Database

 
Unfortunately we're not using ASM.  Disappointing….  Any other
ideas?
 
Jeremy 
PConsider the environment. Please don't print this e-mail unless
you really need to.
 
From:oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Powell, Mark D
Sent: Monday, February 23, 2009 3:27 PM
To: oracle list
Subject: RE: OS Information from Database
 
If you are using ASM to manage your disks then yes there are a slew
of ASM views that you can use like v$asm_diskgroup.  See the Oracle
version# Reference manual.
 
-- Mark D
Powell -- 
Phone (313)
592-5148 
 
 

________________________________
 
From:oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of SHEEHAN, JEREMY
Sent: Monday, February 23, 2009 3:15 PM
To: oracle list
Subject: OS Information from Database
Hey folks,
 
I know there is the V$OSSTAT view where you can see the current
state of the OS, but is there a view where you can see the state of the disk
drives (as in capacity, % full or bytes used vs bytes total) from the db? 
I've got a feeling that there isn't, but I'd figured that I would check.
 
Thanks in advance!
 
Jeremy 
PConsider the environment. Please don't print this e-mail unless
you really need to.


      

--
http://www.freelists.org/webpage/oracle-l