Re: Oracle ODBC performance SUCKS!@

Check if you are using MS ODBC driver for Oracle v2.00 or v.2.70. v2.70 has some problems (like magically converting numbers to characters, ask for 2+7 and you get 27 instead of 9, works wonders on P&L's). If you are using v2.00, then try using Oracle's ODBC driver for Oracle rather than Microsoft's. (Use v2.0x). Perhaps it is your ODBC driver that "sucks".

I'm not sure that you can control this from MSAccess, but you should be using forward-only cursors. Oracle and MS SQLServer handle cursors differently.

Just an FYI, highest benchmark for Oracle on NT (4 processor box) = ~12,000 transactions per minute, highest benchmark for Oracle on unix (Solaris) = ~51,000 transactions per minute, highest benchmark for MS SQLServer on NT (8 processor box) = ~18,000 tpm (last time I looked, anyway). Check www.tpc.org for info that may be more up-to-date.

Regards,
Dave Sisk, certified Oracle DBA

bubba wrote in message <354a4cf3.0_at_news.webt.com>...
>Two identical tables: one in MS SQL Server, the Other in Oracle 8 NT.
>(NT Server 4.0 SP3, 96 MB RAM, PII 266, SCSI Wide 4-g. Stripped system of
no
>other extraneous applications, processes.)
>
>Access 97 linked tables via ODBC (BOth Microsoft ODBC drivers, one for
>oracle, the other SQL Server.)
>
>Loading a page full of data from the Oracle 8 server causes my one-user
load
>NT server performance to sky rocket to 97% for three seconds just to pull
>back a pagefull of data in MS Access via ODBC from the Oracle 8 Server.
>
>Using the same linked table(exact schema) but MSAccess to MS Sql Server
>results in a page of data coming in less than 1 second and NT performance
>monitor shows 2% utilization on the processor for this test.
>
>Now I know that this is informal and not scientific. But , Oracle Sucks!
>
>Every time I hit page down in MS access via ODBC to Oracle 8 it takes three
>to four seconds per page of data. In MS Sql server it's pretty much
>instantaneous.
>
>By the way, I ran each test on the server while only one database server
>process was running(ie., Oracle 8 Alone on the server, then MS SQL Server
>alone on the server.
>
>What the hell is going on?
>
>How can somebody reliably develop with ODBC and Oracle 8? With 1 user
Oracle
>8 is brought to it's knees!
>
>I have Oracle 8 running in the default configuration but with 30mb SGA.
>
>I absolutely have to know if I can tweak Oracle 8 into a usable system for
a
>VB5 to Oracle 8 application via ODBC. If not, I have to explain to my
>customer to switch to MS SQL(they already own oracle 8).
>
>I can't imagine running a 100-user + system on Oracle 8. What's all the
>hubbub about Oracle 8 anyway. Does it just suck on NT or what?
>
>brittonb_at_webt.com
>
>
Received on Sat May 02 1998 - 23:27:07 CDT