Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Client performance.

Client performance.

From: Marcus Hampel <marcus.hampel_at_myview.de>
Date: 2000/06/19
Message-ID: <394E63E9.C6C672B@myview.de>#1/1

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 Mon Jun 19 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US