RE: OS Information from Database
- From: "Powell, Mark D" <mark.powell@xxxxxxx>
- To: "oracle list" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 23 Feb 2009 15:40:59 -0500
You can use the external procedure feature to call an external program
that gathers the information you want to make available within Oracle.
If you ran a shell script or program that collected the data you wanted
and wrote it to a file accessible to Oracle you could use the external
table feature to allow the data to be selected from within Oracle.
-- Mark D Powell --
Phone (313) 592-5148
________________________________
From: SHEEHAN, JEREMY [mailto:JEREMY.SHEEHAN@xxxxxxx]
Sent: Monday, February 23, 2009 3:36 PM
To: Powell, Mark D; oracle list
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:
