RE: OS Information from Database
- From: "SHEEHAN, JEREMY" <JEREMY.SHEEHAN@xxxxxxx>
- To: Deepak Sharma <sharmakdeep_oracle@xxxxxxxxx>, "mark.powell@xxxxxxx" <mark.powell@xxxxxxx>, oracle list <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 23 Feb 2009 16:21:00 -0500
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:
