RE: Question On High Parse to execute ratio

2003-01-14 Thread Jamadagni, Rajendra
Title: RE: Question On High Parse to execute ratio If you are using 9202 and intermedia, intermedia will choke on anything other than exact for cursor_sharing parameter ... and yes, they finally have a patch that works. Raj __ Rajendra

Re: Question On High Parse to execute ratio

2003-01-13 Thread Jay
Thank you all for your help. I will have to review the metalink data as you suggested. We have asked that they Bind their SQL Statement but where given no patch date so it looks like we are out in the cold for awhile. Once again thanks for all your help. Jay - Original Message - To: "Mult

Re: Question On High Parse to execute ratio

2003-01-13 Thread Mogens Nørgaard
And/or get Bjorn Engsigs article (I think it's on MiracleAS.dk under Technical Information - called cursor.pdf) about some interesting results regarding cursor sharing. Mogens Cary Millsap wrote: CURSOR_SHARING won't reduce the "parse count (total)" count; only eliminating parse calls from you

RE: Question On High Parse to execute ratio

2003-01-13 Thread Cary Millsap
CURSOR_SHARING won't reduce the "parse count (total)" count; only eliminating parse calls from your application can do that. Using CURSOR_SHARING will reduce the "parse count (hard)" count (and maybe some shared pool latch contention), but at the expense of more user-mode CPU consumed during each p

RE: Question On High Parse to execute ratio

2003-01-13 Thread Jesse, Rich
Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > -Original Message- > From: Igor Neyman [mailto:[EMAIL PROTECTED]] > Sent: Monday, January 13, 2003 2:39 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: Question On High Parse t

RE: Question On High Parse to execute ratio

2003-01-13 Thread Karen Morton
Jay, Take a look into using stored outlines. If the problem is with the vendor's code not using bind variables, I don't know that this will help, but you may find some instances where it might be useful. I heard recently that a book should be written with just one chapter on bind variables.C

Re: Question On High Parse to execute ratio

2003-01-13 Thread Rajesh . Rao
eyman" ptron.com>cc: Sent by: Subject: Re: Question On High Parse to execute ratio [EM

RE: Question On High Parse to execute ratio

2003-01-13 Thread DENNIS WILLIAMS
Jay - Here are the possibilities: 1. The vendor is stupid. Or doesn't understand Oracle. 2. The product was incorrectly installed. Some products are sophisticated enough to have a configurable interface, which may be misconfigured or need tuning over time. 3. You are missing a key piece o

Re: Question On High Parse to execute ratio

2003-01-13 Thread Igor Neyman
Success with using CURSOR_SHARING depends on your Oracle version. In earlier versions it's buggy. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, January 13, 2003 3:00 PM > Hello: > > I have a thi

Question On High Parse to execute ratio

2003-01-13 Thread Jay Wade
Hello: I have a third party application which seems to have alot of unbound SQL statements, several of which do not seem to be very effective queries. Unfortunatelly the code is locked. My Parse to execute ratio is around 72% and I was wondering if anyone has any ideas on how I can decrease t