Sending HTML AWR reports with unix sendmail
oracle
,
tuning
,
awr
,
scripts
Jose Luis Canciani
A small command to send your AWR html report (from sqlplus you run @?/rdbms/admin/awrrpt.sql).
Un pequeño comando unix para enviar el reporte HTML de AWR (que se obtiene con sqlplus si corres @?/rdbms/admin/awrrpt.sql).
[oracle@DBSERVER]$ cat << EOF | sendmail -t > From: oracle@yourserver.yourcompany.com > To: your.email.address@yourcompany.com > Mime-Version: 1.0 > Content-type: text/html; charset="iso-8859-1" > Subject: AWR report inline > `cat awrrpt_1_10697_10698.html` > EOF