Re: oracle client on PC's

From: Paul Drake <discgolfdba_at_yahoo.com>
Date: Tue, 06 Jan 2004 12:19:43 -0800
Message-ID: <F001.005DBDF1.20040106121943@fatcity.com>

Justin Cave <jcave_at_cableone.net> wrote:
> 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

Justin,

> There is a fair amount of "chatter" between
> an application and the
> Oracle client DLL's.

I'd have to agree:

D:\Oracle\Ora92\bin>pslist sqlplus

Process information for MYHOST:

Name Pid Pri Thd Hnd Mem User Time Kernel Time Elapsed Time
sqlplusw 1764 8 2 105 244 0:00:00.265 0:00:00.281 0:00:27.421

105 handles just for one sqlplus connection. There were 44 handles and 74 references for "KnownDLLs".
check out Process Explorer from the SysInternals website for a gui tool for viewing handle info.

Glad I checked with Process Explorer, I didn't realize that I had client-side tracing enabled in my Oracle 9.2 client (it showed the handle on the trace file).

hth,

Paul

Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Paul Drake
  INET: discgolfdba_at_yahoo.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:19:43 CST