Re: Client performance.

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.
2. Is the code for Oracle/SQLServer working in *exactly* the same way (some code snippets might be useful). In particular opening a connection to a database is an expensive operation , but reusing an open connection object is fast.

"Marcus Hampel" <marcus.hampel_at_myview.de> wrote in message news:394E63E9.C6C672B_at_myview.de...
> hallo,
>
> i have a big problem with the client performance on Oracle. The
> application is able to use MS-SQL-Server or Oracle (8.0.5 or 8.1.5) as
> database.
> A sample request (150 select statements) takes on SQL-Server 0.8s (incl.
> application time). The same request on Oracle takes >4.0s. The data for
> this test should be cached, because i have tried this more than one (and
> there IS no disk activity).
>
> The NT performance tool shows that the Oracle server uses max. 30% of
> CPU. The complete CPU usage ist 100% (client and server are at the same
> machine).
>
> On the oter site the SQL-Server: A small path between CPU usage of the
> Server and the complete CPU usage. So the client doesn't take much time.
>
> I can't find any switch to speed up the Oracle network performance. We
> have tried to use OCI in place of ODBC, but without an important change.
>
> Does anyone knows a solution for such a problem?
>
> My network configuration:
>
> tnsnames.ora:
> DEMO.UNITY =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = IPC)(Key = DEMO))
> (CONNECT_DATA = (SID = DEMO)(GLOBAL_DBNAME = DEMO))
> )
>
> listener.ora:
> USE_PLUG_AND_PLAY_LISTENER = ON
>
> LISTENER =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = DEMO))
> )
>
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (GLOBAL_DBNAME = demo.unity)
> (SID_NAME = DEMO)
> (PRESPAWN_MAX = 10)
> (PRESPAWN_LIST =
> (PRESPAWN_DESC =
> (PROTOCOL = IPC)
> (POOL_SIZE = 5)
> (TIMEOUT = 0)
> )
> )
> )
> )
>
> sqlnet.ora:
> DISABLE_OOB = ON
> NAMES.DEFAULT_DOMAIN = unity
> BREAK_POLL_SKIP = 100
> SQLNET.EXPIRE_TIME = 1
> SQLNET.ENCRYPTION_SERVER = requested
> SQLNET.ENCRYPTION_CLIENT = requested
> NAMES.DIRECTORY_PATH= (TNSNAMES)
>
>
> Thanks,
> Marcus
Received on Tue Jun 20 2000 - 00:00:00 CDT