Re: ORDER BY performance problem

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Mon, 9 Aug 1999 19:33:13 +0200
Message-ID: <934220002.27835.0.pluto.d4ee154e@news.demon.nl>

No,
v$sesstat.
Sorry I don't know the statistic# by heart, you can find them in v$statname.

Hth,

Sybrand Bakker, Oracle DBA

Doug Cowles <dcowles_at_bigfoot.com> wrote in message news:37AF07A6.5EDB66E3_at_bigfoot.com...
> How do you check that? tkprof?
>
> Jason Salter wrote:
>
> > You could check to see if the query is sorting to disk or within
> > memory.
> >
> > Regards,
> > Jason.
> >
> > On Mon, 09 Aug 1999 13:43:50 GMT, franz.mueller_at_orbis.de (Franz
> > Mueller) wrote:
> >
> > >Hi,
> > >
> > >I have a performance problem with a query that ends with "ORDER BY .."
> > >Without the ORDER BY it runs really fast. The difference is really big
> > >(on an answer set with 200 rows). Is there a way to speed up this kind
> > >of query?
> > >
> > >Franz
>
>
>
Received on Mon Aug 09 1999 - 12:33:13 CDT