Date: Tue, 15 Sep 2009 08:40:11 -0700 (PDT)
On Sep 15, 10:01 am, helter skelter <helterskel..._at_gmail.com> wrote:
> 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;
> 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
Looks like a decent solution, I'll try it. However, I am assuming that there are spaces between some of these parameters?
echo -e "$RAPORT_TYPE\n1 $MIN_SNAP $MAX_SNAP\n $RAPORT_NAME\n"
I'll give it a try, but just asking.
Thanks! Received on Tue Sep 15 2009 - 10:40:11 CDT