Re: AWR
From: helter skelter <helterskelter_at_gmail.com>
Date: Wed, 16 Sep 2009 09:28:09 +0200
Message-ID: <h8q3tk$5v4$1_at_mx1.internetia.pl>
Date: Wed, 16 Sep 2009 09:28:09 +0200
Message-ID: <h8q3tk$5v4$1_at_mx1.internetia.pl>
>
> 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"
>
works for me, without spaces:
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_DIR/log.txt
are you using bash ? i'm not sure if it's working in other shells
cheers Received on Wed Sep 16 2009 - 02:28:09 CDT