> I don't have papers to substantiate this, but in our 9012 database > before we > started using cursor_sharing we used to run out of our 600M SGA, but > since > we started using CS, it went down.
That should have nothing to do with the case of a statement and everything to do with using literals. AFAIK, cursor_sharing does not change the case of a statement Saying that the case used to type in the statement causes a performance hit is not true. The performance hit comes from not standardizing the SQL statement, so that Oracle has to reparse it because although it's identical, the case is different so the statement is seen as different. You can use all uppercase, all lowercase, any combination of the two you want, as long as you are consistent. --- "Jamadagni, Rajendra" <[EMAIL PROTECTED]> wrote: > Tom, > > Well it simply comes to when Oracle will parse the query and try to > find a > "matching" sql to hash to in SGA, if it finds one, it will hash to > the same > one, else it will have to create a new hash entry. > > In pre-8i (before the cursor_sharing days) it would treat uppercase > and > lowercase queries are different. > > I don't have papers to substantiate this, but in our 9012 database > before we > started using cursor_sharing we used to run out of our 600M SGA, but > since > we started using CS, it went down. > > Raj > ______________________________________________________ > Rajendra Jamadagni MIS, ESPN Inc. > Rajendra dot Jamadagni at ESPN dot com > Any opinion expressed here is personal and doesn't reflect that of > ESPN Inc. > > QOTD: Any clod can have facts, but having an opinion is an art! > -----Original Message----- > Sent: Monday, September 30, 2002 9:48 AM > To: Multiple recipients of list ORACLE-L > > > Raj, > > Do you have any test cases or white papers to support your statement? > Especially the part about > > "if you mix-n-match that will make Oracle do more work." > > never heard of this before and I am interested if it is true. > Tom Mercadante > Oracle Certified Professional > > ********************************************************************This > e-mail message is confidential, intended only for the named > recipient(s) above and may contain information that is privileged, > attorney work product or exempt from disclosure under applicable law. > If you have received this message in error, or are not the named > recipient(s), please immediately notify corporate MIS at (860) > 766-2000 and delete this e-mail message from your computer, Thank > you.*********************************************************************2 > __________________________________________________ Do you Yahoo!? New DSL Internet Access from SBC & Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
