RE: Curious question about flushing the Pool

> I lost the fight to have the code fixed, and so turned on
> cursor_sharing. Worked like a charm

Been there, done that... but now I feel better knowing that a tenacious goddess of the DBA battlefields also lost this fight. :-)

It's a tough fight when embedded SQL is scattered all over the place and development is more concerned with coding the next feature set on "Internet time." Apart from the tons of embedded SQL, we have a "dynamic SQL generator" function in our code which creates SQL with literals based on states or values in webpage check boxes, radio buttons, dropdownlists, text boxes, etc. Since this is a central, oft-used part of the app I'm hoping to get duhvelopment to use bind variables in it but it's going to be an uphill battle. Just the normal frustration in the on-going DBA/Duhveloper battle. Sigh...

Steve Orr
Bozeman, MONTANA!

-----Original Message-----
Sent: Thursday, April 25, 2002 6:58 AM
To: Multiple recipients of list ORACLE-L Importance: High

Minor correction, cursor_sharing did work in versions under 8.1.7.3 (I used it in 8.1.6) but there was a bug relating to very specific usage. I never encountered it, I know you can look up the details of the bug on Metalink.

Having said that, I used cursor_sharing=force instead of flushing the shared pool because it does almost entirely eliminate the "out of memory" error, while flushing, if you misset the timing, doesn't.

We had programmers who did not want to use bind variables (Java prepared statements) and so, for an OLTP system where they were looking up registration information, we ended up with each SQL statement, differing only by the constant value being looked up, in the shared pool.

I lost the fight to have the code fixed, and so turned on cursor_sharing. Worked like a charm

Rachel

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Orr, Steve
  INET: sorr_at_rightnow.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).