Re: AWR
From: helter skelter <helterskelter_at_gmail.com>
Date: Tue, 15 Sep 2009 17:01:13 +0200
Message-ID: <h8oa33$ppl$1_at_mx1.internetia.pl>
The Magnet wrote:
> So, can this be scripted, since the awrrpt.sql asks for values?
>
...
MAX_SNAP_ID=`sqlplus -S "/ as sysdba" << EOF set heading off
set trimspool on
set feedback off
SELECT trim(max(SNAP_ID)) FROM DBA_HIST_SNAPSHOT; EOF`
...
...
echo -e "$RAPORT_TYPE\n1$MIN_SNAP$MAX_SNAP\n$RAPORT_NAME\n"|(sqlplus -S "/ as sysdba" _at_$ORACLE_HOME/rdbms/admin/awrrpt.sql) >> $LOG_FILES ...
Date: Tue, 15 Sep 2009 17:01:13 +0200
Message-ID: <h8oa33$ppl$1_at_mx1.internetia.pl>
The Magnet wrote:
> So, can this be scripted, since the awrrpt.sql asks for values?
>
...
MAX_SNAP_ID=`sqlplus -S "/ as sysdba" << EOF set heading off
set trimspool on
set feedback off
SELECT trim(max(SNAP_ID)) FROM DBA_HIST_SNAPSHOT; EOF`
...
...
echo -e "$RAPORT_TYPE\n1$MIN_SNAP$MAX_SNAP\n$RAPORT_NAME\n"|(sqlplus -S "/ as sysdba" _at_$ORACLE_HOME/rdbms/admin/awrrpt.sql) >> $LOG_FILES ...
this should help
cheers Received on Tue Sep 15 2009 - 10:01:13 CDT