Re: 100 hard parses per second in 10.2 database
From: Mark D Powell <Mark.Powell_at_eds.com>
Date: Mon, 17 Aug 2009 09:10:49 -0700 (PDT)
Message-ID: <8957f8b7-7482-44de-9fcb-e53e18551a0d_at_k19g2000yqn.googlegroups.com>
On Aug 17, 3:31 am, ca111026 <ca111..._at_gmail.com> wrote:
> This is complex application, I cannot test it myself. The tests for
> 10.2.0.4 patch set were done by testing team, they didn't find any
> issues, but when it went to production there were multiple problems.
> We rolled back. More testing, second attempt also ended in rollback.
> Obviously there is an issue with testing but this is not something I
> can fix. The amount of time allocacted for testing of cursor_sharing
> change was rather limited, testing team found some issues (basically
> some statements using different plans) and this was it.
Date: Mon, 17 Aug 2009 09:10:49 -0700 (PDT)
Message-ID: <8957f8b7-7482-44de-9fcb-e53e18551a0d_at_k19g2000yqn.googlegroups.com>
On Aug 17, 3:31 am, ca111026 <ca111..._at_gmail.com> wrote:
> This is complex application, I cannot test it myself. The tests for
> 10.2.0.4 patch set were done by testing team, they didn't find any
> issues, but when it went to production there were multiple problems.
> We rolled back. More testing, second attempt also ended in rollback.
> Obviously there is an issue with testing but this is not something I
> can fix. The amount of time allocacted for testing of cursor_sharing
> change was rather limited, testing team found some issues (basically
> some statements using different plans) and this was it.
I agree with Palooka, that trying to change cursor_sharing to FORCE is a bad idea. There have been numerous bugs related to wrong results with this setting. SIMILIAR is generally safer to use, but even using it we ran into serious trouble in the past.
The application should be fixed to use bind variables.
HTH -- Mark D Powell -- Received on Mon Aug 17 2009 - 11:10:49 CDT