Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Client performance.
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 =Received on Mon Jun 19 2000 - 00:00:00 CDT
(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
![]() |
![]() |