Re: SQL Tuning Advisor

From: Guenadi Jilevski <gjilevski_at_gmail.com>
Date: Mon, 9 May 2011 22:51:47 +0300
Message-ID: <BANLkTi=HAAbHDiL+BfpOw4RWksDAj8gPWQ_at_mail.gmail.com>

See also if you can get SQL Repair advisor to generate a patch if the SQL statement crashes apart from involving OSS.

Regards,

Guenadi Jilevski

On Mon, May 9, 2011 at 9:39 PM, Mark W. Farnham <mwf_at_rsiz.com> wrote:

> That depends on your definition of harm. Other than losing possible
> improvements that the tuning advisor might otherwise arrive at, I can’t
> think of a problem. I do hope you submit the SR so they can figure out the
> bug. I **think** if it dumps core then it is a bug no matter what else is
> going on.
>
> mwf
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Jeffrey Beckstrom
> *Sent:* Friday, May 06, 2011 3:06 PM
> *To:* oracle-l-freelists; oracle-db-l
> *Subject:* SQL Tuning Advisor
>
>
>
> Since upgrading to 11.1.0.7, the SQL Tuning Advisor is generating a core
> dump every night on one SQL statement. In the application, the statement
> runs fine. Is there any harm in disabling the Tuning Advisor?
>
>
>
>
>
> Jeffrey Beckstrom
> Database Administrator
> Greater Cleveland Regional Transit Authority
>
> Information Systems
> 1240 W. 6th Street
> Cleveland, Ohio 44113
>

--
http://www.freelists.org/webpage/oracle-l

Received on Mon May 09 2011 - 14:51:47 CDT