It is pretty easy in Oracle to do a case insensitive search without using
function based indexes been doing it for years. As for ora-1555 haven't had
one in more than 5 years and I work daily in Oracle; it isn't too difficult
to configure things so you don't get them. Go to the Ask Tom Site (link off
the Oracle magazine site) and do a search. Great info there. (also you can
get his book which has tons of useful information and is well worth the $50)
I would rather occaisionally get the ora-1555 than have so much contention
and problems with locking. (Perfect example was the usmint.org site where I
tried to fill out their online survey. About 50% of the time I would get a
SQL Server error about unable to insert a record because there was a lock
already and I lost waiting for the lock to be released. )
Jim
"Keith Boulton" <kboulton_at_ntlunspam-world.com> wrote in message
news:GlQ87.19957$vN4.137404_at_news11-gui.server.ntli.net...
> In 8i, function-based indexes are available only in the enterprise
edition -
> and it's not worth an extra $500 per client or whatever the difference is
> now.
>
> Given how trivial it is to implement a case insensitive search and how
> useful, I'm astonished that Oracle still haven't provided it (too busy
> writing the world's most resource hungry installer, I guess).
>
> As for readers not blocking writers, that's right, we get ORA-1555
snapshot
> too old instead.
>
>
> "Nuno Souto" <nsouto_at_optushome.com.au.nospam> wrote in message
> news:3b62f4ca.3392270_at_news...
> > On Sat, 28 Jul 2001 16:39:39 GMT, "Jim Kennedy"
> > <kennedy-family_at_home.com> wrote:
> >
> > >Yeah, and I can't seem to get my writers and readers to block each
other
yet
> > >like all those other RDBMSs.
> > >
> >
> > Hehehe!
> > You wish...
> >
> > Cheers
> > Nuno Souto
> > nsouto_at_optushome.com.au.nospam
>
>
Received on Sun Jul 29 2001 - 10:56:01 CDT
