Re: Oracle8 performance problems under NT

We have similiar problem. After we upgrade database from 7.3.4 to 8.1.6. We have been test ODBC version 2.5 (7.3.4) and ODBC 8.1.6.1 , the ODBC version 2.5 have better performance. Same sql statement on ODBC 2.5 toke 2 minutes, but ODBC 8.1.6.1 toke 10+ minutes. We still don't know why? We will still stay on ORACLE client 7.3.4 until figure out the problem.

Thanks.

In article <api6lsg4c7ii96q3ofuo70nupobomitjr0_at_4ax.com>,   Azamat Khalilov <aza_at_nospam.ru> wrote:
>
> There was a flame about comparing ODBC with MS SQL and Oracle already.
> Use dejanews to search.
> The problem was repeatedly connect/disconnect to Oracle with every
> query.
> It's not necessary in real world.
>
> On Thu, 22 Jun 2000 21:10:54 GMT, Michael Bialik
> <michael_bialik_at_my-deja.com> wrote:
>
> >Did you try using rule based optimizer?
> >Is it possible to post 1-2 queries + EXPLAINm,index definition and
> >some stats?
> >
> > Michael.
> >
> >
> >In article <Uqu45.475$482.137897_at_den-news1.rmi.net>,
> > "Josh Sale" <jsale_at_tril.com> wrote:
> >> We have a mature mostly read-only application that runs on Windows
 clients.
> >> It supports both SQL Server and Oracle as databases. We've had
 great
> >> performance from Oracle8 on various UNIX platforms but have
 recently
 been
> >> scratching our heads over poor performance on NT with 8.1.5.0.0.
> >>
> >> To give you an idea, we've extracted 55 queries that the
 application
> >> performs. If we run those queries against Oracle, they take a
 little
 over 7
> >> seconds to complete. When the exact same queries are run against
 the
> >> identical database using SQL Server they complete in .7 seconds!
 Most of
> >> the queries are simply single table queries although a few are
 joins.
> >> Nothing to hairy.
> >>
> >> All of the tables have been fully analyzed. We aren't using any
 Hints. The
> >> explain plans look OK. We've messed around with various init.ora
 parameters
> >> without impacting anything. The client is connected to a lightly
 loaded
> >> 100mb network.
> >>
> >> We've run a SQL trace and it shows the queries performing utilizing
 trivial
> >> amounts of CPU time and zero I/O. Mostof the elapsed time is
 accounted for
> >> as fetch time (even though none of the queries return more than a
 few
 rows).
> >>
> >> Has anybody encountered poor Oracle8 performance on NT?
> >>
> >> Has anybody encountered a problem collecting I/O statistics with
 SQL
 trace
> >> on NT?
> >>
> >> TIA
> >>
> >> josh
> >>
> >>
> >
> >
> >Sent via Deja.com http://www.deja.com/
> >Before you buy.
>
> --- Azamat Khalilov --- aza(a)aisdev*gns*bashnet*ru ---
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Jun 23 2000 - 00:00:00 CDT