Re: DB File Sequential Read Waits

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Wed, 31 Dec 2003 10:19:00 -0000
Message-ID: <3ff2a295$0$13349$ed9e5944@reading.news.pipex.net>

"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

Received on Wed Dec 31 2003 - 04:19:00 CST