Re: Library Cache question
- From: Cary Millsap <cary.millsap@xxxxxxxxxxxx>
- To: martinfbrown@xxxxxxxxxxx
- Date: Fri, 6 Feb 2009 09:56:35 -0600
(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@xxxxxxxxx> wrote:
>
> On Fri, Feb 6, 2009 at 7:12 AM, Martin Brown <martinfbrown@xxxxxxxxxxx>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
>
>
>
Other related posts:
