Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle performance tuning question

Re: Oracle performance tuning question

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Sat, 25 Jan 2003 14:01:07 -0000
Message-ID: <3e3298a5$0$234$cc9e4d1f@news.dial.pipex.com>


"DA Morgan" <damorgan_at_exesolutions.com> wrote in message news:3E31024B.2D2F128C_at_exesolutions.com...
> Niall Litchfield wrote:
>
> > "DA Morgan" <damorgan_at_exesolutions.com> wrote in message
> > news:3E2C287D.2A45F060_at_exesolutions.com...
> > <snip>
> > > > WHERE (((SSA_NAME between :l_ie_srch_range.from[0] AND
> > > > :l_ie_srch_range.to[0])
> >
> > > Lots of questions ... not so many suggestions. Here they are in no
> > > particular order?
> > <snip>
> > > 11. Why is gl_sysdate stored as a string?
> >
> > and
> >
> > 12 what exactly does :l_ie_srch_range.from[0] mean? what data type is
> > SSA_NAME.
> >
> > --
> > Niall Litchfield
> > Oracle DBA
> > Audit Commission UK
> > *****************************************
> > Please include version and platform
> > and SQL where applicable
> > It makes life easier and increases the
> > likelihood of a good answer
> >
> > ******************************************
>
> I hope you don't think I wrote that: I didn't.

I didn't think you wrote the SQL just the list of questions. You are correct though it was overzealous snipping on my part.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
Received on Sat Jan 25 2003 - 08:01:07 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US