RE: SQL Tuning Advisor

From: Mark W. Farnham <mwf_at_rsiz.com>
Date: Mon, 9 May 2011 14:39:05 -0400
Message-ID: <007501cc0e78$60940700$21bc1500$_at_rsiz.com>



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 - 13:39:05 CDT

Original text of this message