Re: OS Information from Database
- From: Rodd Holman <rodd.holman@xxxxxxxxx>
- To: mark.powell@xxxxxxx
- Date: Mon, 23 Feb 2009 15:19:45 -0600
As oracle user on AIX box you can put the following in cron.
05,15,25,35,45,55 * * * * /usr/bin/df -kI|/usr/bin/grep
/path_to_datafile_filesystems/lgarsprd
>/some_path/ORACLE_SID_datafile_df.csv
2>/some_path_for_logs/ORACLE_SID_datafile_df.error
Then you just build an external table off the ORACLE_SID_datafile_df.csv
file. It's really nice, because you can join it to dba_data_files and
report on disk usage by tablespace.
The above will work on other *nix systems, but you may have to adjust
the df options to your liking.
Rodd Holman
Powell, Mark D wrote:
> 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
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
