Thank you.. That is helpful.
On 1/5/07, Allen, Brandon <Brandon.Allen_at_oneneck.com> wrote:
>
> Yes AWR does keep the explain plans - check dba_hist_sql_plan (or just
> look at it through the DB Console/Grid Control GUI), and yes it could've
> helped for last month, assuming you set your AWR retention appropriately.
> IIRC, it defaults to only 1 week, but I bumped mine up to 45 days
> specifically for the purpose of covering monthly queries.
>
> HTH,
> Brandon
>
> Privileged/Confidential Information may be contained in this message or
> attachments hereto. Please advise immediately if you or your employer do not
> consent to Internet email for messages of this kind. Opinions, conclusions
> and other information in this message that do not relate to the official
> business of this company shall be understood as neither given nor endorsed
> by it.
>
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jan 05 2007 - 14:06:16 CST
