Re: Client performance.

I totally agree with Michael. The first stage in investigating poor application performance should always be to see what it is doing. It is not sufficient to say that SQL Server and Oracle are running comparable statements, as Oracle's optimizer will be completely different.

You may well find that the addition of an index or two will vastly improve the Oracle performance. Try SQL tracing the client session (alter session set sql_trace = true) and then TKPROF the resulting trace file.

(However, I'm a little surprised if you're getting no disk activity).

Dave.

In article <0mU35.5881$ef.34709_at_news4.atl>,   "Michael D. Long" <lead_dog_at_bellsouth.net> wrote:
>
> Have you looked at the execution plans? Do they agree
> with what you expect?
>
> I've found that when improperly tuned Oracle will not
> perform as well as SQL Server on the same box. When
> well tuned and with queries that effectively utilize the
> indexes Oracle performs better.
>
> --
> Michael D. Long
> http://extremedna.homestead.com
>
> "Marcus Hampel" <marcus.hampel_at_myview.de> wrote in message
> news:394F809B.DBCC4A01_at_myview.de...
> > Hello.
> >
> > Niall Litchfield wrote:
> > >
> > > couple of things that might be worth looking at
> > >
> > > 1) Try changing the ODBC driver - in general the ms ones are
 better >
 but
> > > sometimes you get better results with Oracle provided drivers.
> > We have also created an OCI driver for a Linux version. Exactly the
 same
> > problem. I have also tried third party products => All solutions
 doesn't
> > provide important performance improvements (max. 10-20%).
> >
> > > 2) Is the code for Oracle/SQLServer working in *exactly* the same
 way
> > Exactly the same way. Only the data souce changed.
> >
> > >(some
> > > code snippets might be useful).
> > Which of the 150 statemant does you want to see :X)
> >
> > > In particular opening a connection to
> > > a database is an expensive operation , but reusing an open
> > > connection object is fast.
> > Ok, this is true. It take 0.25s on Oracle. But where is the rest of
 the
> > 4s? And why does the client gets such hight CPU load? It's not the
> > application itself.
> >
> > Thanks,
> > Marcus
>
>

--
Any opinions expressed in the above posting are entirely factual and obj
Please do not argue with me, as my Dad is bigger than your Dad.


Sent via Deja.com http://www.deja.com/
Before you buy.