Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DB File Sequential Read Waits
The more people who use this, the more
bugs, or deficiencies, get discovered.
For example (deficiency) it does force
sharing of anonymous pl/sql blocks, like:
begin
run_my_procedure('A');
end;
begin
run_my_procedure('B');
end;
Although it will work with
call run_my_procedure('A');
call run_my_procedure('B');
But then Connor pointed out a few days ago that if you had real bind variables mixed in with the literals your session would crash.
-- Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html ____UK___November The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:3ff2a295$0$13349$ed9e5944_at_reading.news.pipex.net...Received on Wed Dec 31 2003 - 05:00:55 CST
> "Noons" <wizofoz2k_at_yahoo.com.au.nospam> wrote in message
> news:3ff1a45f$0$18752$afc38c87_at_news.optusnet.com.au...
> > > Yes no bind variables being used at all. I am talking with developers
> > > about this now.
> >
> > Yikes! That alone is a killer... You might need the parameter
> > to take care of parses when bind variables not used, what was it
> > again, anyone?
> >
> on 8.1.6 it is
>
> CURSOR_SHARING=FORCE
>
> On 8.1.6 in my experience it is buggy though. I haven't yet been burned
with
> CURSOR_SHARING=SIMILAR on 9.2, We experienced app crashes when we tried
this
> on 816.
>
> It also doesn't exactly take care of excessive parsing, but it makes the
> excessive parsing less expensive.
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> >