Our Oracle DBA turned Plan Stability off and the error no longer returns. He said that we will leave Plan Stability off until Oracle fixes a bug in that utility but performance will be impacted because the queries will run erratically. I asked when they turned Plan Stability on and was told that it has been running for a long time with no issue. I am thinking that if there is a bug in the utility then maybe there have been issues with performance already.
From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Pierson, Shawn Sent: Thursday, February 20, 2014 9:23 AM To: [email protected] Subject: Re: SQL Error when Refreshing Incident Console ** This is a definite sign that someone is monkeying around with your database. Have you asked your DBAs to help with performance tuning on Remedy lately? Thanks, Shawn Pierson Remedy Developer | Energy Transfer From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Tommy Morris Sent: Thursday, February 20, 2014 9:10 AM To: [email protected]<mailto:[email protected]> Subject: SQL Error when Refreshing Incident Console ** I am receiving "ARERR [552] The SQL database operation failed. : ORA-38141: SQL plan baseline SYS_SQL_PLAN_19c5fd83b7bfd1e7 does not exist" when refreshing the Incident Console. When the Console first opens and the table refreshes it returns the error, when I hit the Refresh icon it returns. However, if I select Open (under Incident Counts) then the table refreshes fine. This is only affecting Incident Console and is present in both in User Tool and mid-Tier. ARS 7.6.04 ITSM 7.6.sp3 Oracle Tommy Morris Sr. Remedy Developer | RadioShack Office# 817-415-2510 _ARSlist: "Where the Answers Are" and have been for 20 years_ Private and confidential as detailed here<http://www.energytransfer.com/mail_disclaimer.aspx>. If you cannot access hyperlink, please e-mail sender. _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
