Re: DB File Sequential Read Waits

From: Noons <wizofoz2k_at_yahoo.com.au.nospam>
Date: Wed, 31 Dec 2003 21:29:28 +1100
Message-ID: <3ff2a666$0$18750$afc38c87@news.optusnet.com.au>

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:3ff2a295$0$13349$ed9e5944_at_reading.news.pipex.net...

>
> on 8.1.6 it is
>
> CURSOR_SHARING=FORCE
's the one! thanks a lot. Caramba, it's been a while since I used that...

> On 8.1.6 in my experience it is buggy though.

there is very little in 8.1.6 that isn't buggy... It blew up miserably with some of the OO work I was doing two years ago. 8.1.7 held up well, after patching its behind all over the place!

> It also doesn't exactly take care of excessive parsing, but it makes the
> excessive parsing less expensive.

Yup, that is the case.

-- 
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam

Received on Wed Dec 31 2003 - 04:29:28 CST