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.
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-lReceived on Mon May 09 2011 - 13:39:05 CDT