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-----
From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 30, 2002 9:48 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Does the case of an Oracle query statement affect query perfo
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
