Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!news-FFM2.ecrc.net!newsfeed.stueberl.de!ecngs!feeder.ecngs.de!newsfeed.kabelfoon.nl!195.129.110.21.MISMATCH!bnewsfeed00.bru.ops.eu.uu.net!bnewsinpeer00.bru.ops.eu.uu.net!lnewspeer00.lnd.ops.eu.uu.net!lnewspost00.lnd.ops.eu.uu.net!emea.uu.net!not-for-mail
From: "Niall Litchfield" <n-litchfield@audit-commission.gov.uk>
Newsgroups: comp.databases.oracle.misc
References: <65275ae5.0306250757.b859f09@posting.google.com> <3EF9C9FA.2621AE77@exxesolutions.com> <65275ae5.0306251533.24adf1b3@posting.google.com> <3EFB1781.BAA7CC10@exxesolutions.com> <bdovv9$mbc$1@pheidippides.axion.bt.co.uk> <3F006029.ECE34F77@exxesolutions.com> <Xns93AA90561808Bpingottpingottbah@130.133.1.4> <3F0097B2.F3CEDF47@exxesolutions.com> <xt1Ma.174$GQ2.27057325@newssvr21.news.prodigy.com> <3F0246B0.9070803@adelphia.net> <pQCMa.166$4k.22@newssvr16.news.prodigy.com> <3F02FFB0.6F579E3B@remove_spam.peasland.com> <C_DMa.187$NU2.94@newssvr16.news.prodigy.com> <Xns93AC927472945pingottpingottbah@130.133.1.4> <7EGMa.242$QJ.194@newssvr16.news.prodigy.com> <3f0494aa$0$10623$cc9e4d1f@news.dial.pipex.com> <Xns93B0DE7FB8D39pingottpingottbah@130.133.1.4>
Subject: Re: Which is faster?  <> or Between
Date: Mon, 7 Jul 2003 09:31:27 +0100
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Lines: 29
Message-ID: <3f092fe0$0$18489$ed9e5944@reading.news.pipex.net>
NNTP-Posting-Host: host9.audit-commission.gov.uk
X-Trace: 1057566688 reading.news.pipex.net 18489 193.128.236.219
X-Complaints-To: abuse@uk.uu.net
Xref: newssvr20.news.prodigy.com comp.databases.oracle.misc:129081

You've gotta slow these guys down somehow. Errm or ensure that they use
statement_id.


-- 
Niall Litchfield
Oracle DBA
Audit Commission UK
"Pablo Sanchez" <honeypot@blueoakdb.com> wrote in message
news:Xns93B0DE7FB8D39pingottpingottbah@130.133.1.4...
> "Niall Litchfield" <niall.litchfield@dial.pipex.com> wrote in
> news:3f0494aa$0$10623$cc9e4d1f@news.dial.pipex.com:
>
> > "Isaac Blank" <izblank@yahoo.com> wrote in message
> > news:7EGMa.242$QJ.194@newssvr16.news.prodigy.com...
> >
> > conn system/<pwd>;
> > @?/rdbms/admin/utlxplan
> > create public synonym plan_table for plan_table;
> > grant all on plan_table to public;
> >
> >:(
>
> :( indeed; one table for all to share!  <g>
> -- 
> Pablo Sanchez, Blueoak Database Engineering
> http://www.blueoakdb.com