--- Justin Cave <[EMAIL PROTECTED]> 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 PsList 1.23 - Process Information Lister Copyright (C) 1999-2002 Mark Russinovich Sysinternals - www.sysinternals.com 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
