Re: Library Cache question
Date: Fri, 6 Feb 2009 09:56:35 -0600
Message-ID: <3a2a84fc0902060756g40de8b76yb8354a348f4b1e5b_at_mail.gmail.com>
(to fortify Jared's point...)
...Because it just doesn't make any sense for the database to keep a cursor that doesn't ever get reused. And what kind of session is going to reuse a SQL statement with string literals boiled in for, say part numbers or date values with 1-second granularity?
Cary Millsap
http://method-r.com
http://carymillsap.blogspot.com
On Fri, Feb 6, 2009 at 9:49 AM, Jared Still <jkstill_at_gmail.com> wrote:
>
> On Fri, Feb 6, 2009 at 7:12 AM, Martin Brown <martinfbrown_at_hotmail.com>wrote:
>
>> ... Unfortunately, our developers ar not fans of bind variables
>> either.
>>
>
> You may have nailed it right there.
>
> The high miss rate would seem to be an indication of that.
>
>
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Feb 06 2009 - 09:56:35 CST