Shulou(Shulou.com)06/01 Report--

#! / bin/bash

Echo-e "\ n\ n*~~DATE:" `date'+% Y/%m/%d% T'` "~ *" > > / home/oracle/tablespace.log

Export PATH=/opt/oracle/1102/db01/bin:$PATH

Export ORACLE_HOME=/opt/oracle/1102/db01/

Sqlplus-S / nolog > / home/oracle/tablespace.log

Exit

# # #

Save the above to / tmp/tablespace.sh

Then use the crontab-l-u oracle command to create a new scheduled task as follows:

1 * / bin/bash tmp/tablespace.sh

The script will be executed every hour, and the results will be saved to home/oracle/tablespace.log

# # #

The above is verified in redhat6.4

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.