Re: OS Information from Database
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
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.
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
> -- Mark D Powell --
> Phone (313) 592-5148