RE: oracle client on PC's

From: Odland, Brad <Brad.Odland_at_qtiworld.com>
Date: Tue, 06 Jan 2004 12:29:25 -0800
Message-ID: <F001.005DBDF2.20040106122925@fatcity.com>

Usually it is installed and configured as a part of a standard corporate disk image.

Many shops will trim the fat off the client to keep the size down.

Or you walk around with a CD.....

-----Original Message-----
From: Jeffrey Beckstrom [mailto:JBECKSTROM@gcrta.org]
Sent: Tuesday, January 06, 2004 2:14 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: oracle client on PC's

The application is a third-party application using Merant's ODBC driver.

How do people normally install the client. Do you do an install to every workstation???

>>> jcave@cableone.net 1/6/04 2:54:34 PM >>>

At 11:39 AM 1/6/2004, Jeffrey Beckstrom wrote:
>Rather than installing the Oracle client on every client PC, we have been:
>- installing client on 1 PC
>- copying directory to a network server
>- extract the registry for "oracle" key
>- fix registry that was extracted to reference the network drive
>- load registry on client PCs
>- add the network pc as a search drive to the client pc.
>
>We are now experiencing problems over the WAN and looking at ways to
>eliminate the Oracle dll overhead. Short of installing Oracle on every
>client PC, what are our options?

There is a reason that Oracle doesn't support configurations like
this. There is a fair amount of "chatter" between an application and the
Oracle client DLL's. When this chatter starts flying over the network
rather than merely going to a local DLL, you start to get performance problems.

How are your application(s) designed? It's probably possible to tweak an
OCI application to make fewer OCI calls. If you're using ODBC, and have
the budget, you could purchase one of the wire-protocol ODBC drivers.

Justin Cave
Distributed Database Consulting

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Justin Cave
INET: jcave@cableone.net

Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Odland, Brad
  INET: Brad.Odland_at_qtiworld.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Tue Jan 06 2004 - 14:29:25 CST