RE: OS Information from Database

That's another route I could take, but…  (please don't groan too much) the 
particular instance where I need this information is on Windows (was NOT my 
preference and was done primarily for as a cost benefit).  I think I'll follow 
up with this or Mark's idea on how to get htat information out of a query.  
External tables it is!

Thanks, all!

Jeremy
P Consider the environment. Please don't print this e-mail unless you really 
need to.

From: Deepak Sharma [mailto:sharmakdeep_oracle@xxxxxxxxx]
Sent: Monday, February 23, 2009 4:11 PM
To: SHEEHAN, JEREMY; mark.powell@xxxxxxx; oracle list
Subject: 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@xxxxxxx>
To: "mark.powell@xxxxxxx" <mark.powell@xxxxxxx>; oracle list 
<oracle-l@xxxxxxxxxxxxx>
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
P Consider the environment. Please don't print this e-mail unless you really 
need to.

From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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
P Consider the environment. Please don't print this e-mail unless you really 
need to.

Other related posts: