RE: OS Information from Database
Date: Mon, 23 Feb 2009 16:21:00 -0500
Message-ID: <8833494F383585499CB855121711D2631035D5BAB5_at_JBXEXVS02.fplu.fpl.com>
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_at_yahoo.com] Sent: Monday, February 23, 2009 4:11 PM To: SHEEHAN, JEREMY; mark.powell_at_eds.com; 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_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
P Consider 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
P Consider the environment. Please don't print this e-mail unless you really need to.
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Feb 23 2009 - 15:21:00 CST