Jim,

Thanks for the reply. The adding break_poll_skip=1024 improved the
performance of the sql*net and brought it in line with direct connections.
The ECO's will be applied at the next downtime window.

Dave.
At 17:05 16-05-05, you wrote:
>I have many suggestions
>
>1. edit sqlnet.ora add the following line
>
>break_poll_skip=1024
>
>
>2. install the latest Kernel,ucxdriver, and ucx emulation ecos.
>
>
>3. If you still have a problem we have seen a site where the only
>resolution for them was to upgrade to Oracle 9i I assume anything greater
>than that as well.
>
>
>4. of course you could always open a case with us.
>
>
>In cases 1 and 3 this was regarding 8.1.7.4 not sure how that applies to
>8.1.7.3
>
>
>Jim
>
>
>
>At 02:42 PM 5/16/2005, you wrote:
>>This is a long shot and at this stage of the game my focus is broad. This
>>the reason for this query.
>>
>>the players:
>>
>>Oracle 8.1.7.3
>>Multinet 4.4 with patches listed below: (NOTE: I know I'm a bit behind
>>with some of the patches, But I am unable to access the FTP site, not
>>sure if it is it is the client or the server.)
>>OpenVMS Alpha 7.2-2
>>
>>The problem:
>>
>>When connected to oracle while logged onto the VMS box I see a
>>performance problem when connected using sqlplus user/password versus
>>sqlplus user/pass@connectString.
>>
>>Connect string is the local host.
>>
>>Executing the same sample query gives the exact same result but the
>>first connection method runs in 12 seconds. The latter takes 55
>>seconds. This is consistent on another OpenVMS box with the same Oracle
>>and Multinet configurations.
>>
>>I would expect that there would be a slight difference in the performance
>>of the two connections, but not that significant.
>>
>>Any Ideas?
>>
>>Dave
>>
>>$ mu show/version
>>Process Software MultiNet V4.4 Rev A-X, Compaq AlphaServer GS140 6/525,
>>OpenVMS AXP V7.2-2
>>
>>VERSION V4.4
>>REVISION A-X
>>DATE 30-Jan-2002
>>PRODUCER PSC
>>INSTALLED_IPAPPS YES
>>INSTALLED_NFSCLIENT YES
>>INSTALLED_NFSSERVER YES
>>INSTALLED_NETWARESERVER NO
>>INSTALLED_SECUREIP_CLIENT NO
>>INSTALLED_SECUREIP_SERVER NO
>>INSTALLED_WEB_SERVER NO
>>INSTALLED_DOCUMENTATION YES
>>INSTALLED_LIBRARIES YES
>>XREPLACED FTP.VUI FTP-022_A044 13-NOV-2002
>>XREPLACED FTP_SERVER.VUI FTP-022_A044 13-NOV-2002
>>XREPLACED MULTINET_SMTP_SYMBIONT.VUI SMTP-020_A044
>>13-NOV-2002
>>XREPLACED SMTP_MAILSHR.VUI SMTP-020_A044 13-NOV-2002
>>XREPLACED SMTP_SERVER.VUI SMTP-020_A044 13-NOV-2002
>>XREPLACED LOAD_SSHLEI.VUI SSH-040_A044 13-NOV-2002
>>XREPLACED MULTINET_CLD.VUF SSH-040_A044 13-NOV-2002
>>XREPLACED MULTINET_HLB.VUF SSH-040_A044 13-NOV-2002
>>XREPLACED SCP-SERVER1.VUI SSH-040_A044 13-NOV-2002
>>XREPLACED SCP2.VUI SSH-040_A044 13-NOV-2002
>>XREPLACED SFTP-SERVER2.VUI SSH-040_A044 13-NOV-2002
>>XREPLACED SSH-ADD2.VUI SSH-040_A044 13-NOV-2002
>>XREPLACED SSH-AGENT2.VUI SSH-040_A044 13-NOV-2002
>>XREPLACED SSH-KEYGEN.VUI SSH-040_A044 13-NOV-2002
>>XREPLACED SSH-KEYGEN2.VUI SSH-040_A044 13-NOV-2002
>>XREPLACED SSH-PROBE2.VUI SSH-040_A044 13-NOV-2002
>>XREPLACED SSH-SIGNER2.VUI SSH-040_A044 13-NOV-2002
>>XREPLACED SSH2.VUI SSH-040_A044 13-NOV-2002
>>XREPLACED SSHD.VUI SSH-040_A044 13-NOV-2002
>>XREPLACED SSHD2.VUI SSH-040_A044 13-NOV-2002
>>XREPLACED SSHD2_CONFIG_TEMPLATE.VUF SSH-040_A044
>>13-NOV-2002
>>XREPLACED SSHD_MASTER.VUI SSH-040_A044 13-NOV-2002
>>XREPLACED SSHLEI.VUI SSH-040_A044 13-NOV-2002
>>XREPLACED SSHREGEX_TXT.VUF SSH-040_A044 13-NOV-2002
>>XREPLACED START_SSH_COM.VUF SSH-040_A044 13-NOV-2002
>>XREPLACED UNLOAD_SSHLEI.VUI SSH-040_A044 13-NOV-2002
>>XREPLACED USER_CLD.VUF SSH-040_A044 13-NOV-2002
>>XREPLACED UCXDRIVER.VUI UCXDRIVER-020_A044 13-NOV-2002
>>XREPLACED NTPDATE.VUI XNTP-020_A044 13-NOV-2002
>>XREPLACED NTPQ.VUI XNTP-020_A044 13-NOV-2002
>>XREPLACED NTPTRACE.VUI XNTP-020_A044 13-NOV-2002
>>XREPLACED START_XNTPD_COM.VUF XNTP-020_A044 13-NOV-2002
>>XREPLACED XNTPD.VUI XNTP-020_A044 13-NOV-2002
>>XREPLACED XNTPDC.VUI XNTP-020_A044 13-NOV-2002
>>XREPLACED MULTINET.VUI KERNEL-UPDATE-040_A044 13-NOV-2002
>>XREPLACED DNSKEYGEN.VUI NAMED-011_A044 26-NOV-2002
>>XREPLACED DNSSIGNER.VUI NAMED-011_A044 26-NOV-2002
>>XREPLACED NAMED-XFER.VUI NAMED-011_A044 26-NOV-2002
>>XREPLACED NAMED.VUI NAMED-011_A044 26-NOV-2002
>>XREPLACED NSUPDATE.VUI NAMED-011_A044 26-NOV-2002
>>XREPLACED FTP.VUI FTP-030_A044 4-DEC-2002
>>XREPLACED FTP_SERVER.VUI FTP-030_A044 4-DEC-2002
>>XREPLACED MULTINET_DECODE.VUI SMTP-030_A044 4-DEC-2002
>>XREPLACED MULTINET_SMTP_SYMBIONT.VUI
>>SMTP-030_A044 4-DEC-2002
>>XREPLACED SMTP_MAILSHR.VUI SMTP-030_A044 4-DEC-2002
>>XREPLACED SMTP_SERVER.VUI SMTP-030_A044 4-DEC-2002
>>XREPLACED FTP.VUI FTP-041_A044 7-MAR-2003
>>XREPLACED FTP_SERVER.VUI FTP-041_A044 7-MAR-2003
>>XREPLACED SNMPD.VUI SNMP-040_A044 7-MAR-2003
>>XREPLACED MULTINET.VUI KERNEL-UPDATE-070_A044 22-NOV-2003
>>XREPLACED SNMPD.VUI SNMP-051_A044 22-NOV-2003
>>XREPLACED MULTINET_SOCKET_LIBRARY.VUI
>>SOCKET_LIBRARY-010_A044 22-NOV-2003
>>XREPLACED KRB$RTL32.VUI SSH-062_A044 22-NOV-2003
>>XREPLACED LOADABLE_SSH_CONTROL.VUI SSH-062_A044 22-NOV-2003
>>XREPLACED LOAD_SSHLEI.VUI SSH-062_A044 22-NOV-2003
>>XREPLACED MULTINET_CLD.VUF SSH-062_A044 22-NOV-2003
>>XREPLACED MULTINET_HLB.VUF SSH-062_A044 22-NOV-2003
>>XREPLACED SCP-SERVER1.VUI SSH-062_A044 22-NOV-2003
>>XREPLACED SCP2.VUI SSH-062_A044 22-NOV-2003
>>XREPLACED SFTP-SERVER2.VUI SSH-062_A044 22-NOV-2003
>>XREPLACED SFTP2.VUI SSH-062_A044 22-NOV-2003
>>XREPLACED SSH-ADD2.VUI SSH-062_A044 22-NOV-2003
>>XREPLACED SSH-AGENT2.VUI SSH-062_A044 22-NOV-2003
>>XREPLACED SSH-CERTENROLL2.VUI SSH-062_A044 22-NOV-2003
>>XREPLACED SSH-KEYGEN.VUI SSH-062_A044 22-NOV-2003
>>XREPLACED SSH-KEYGEN2.VUI SSH-062_A044 22-NOV-2003
>>XREPLACED SSH-PROBE2.VUI SSH-062_A044 22-NOV-2003
>>XREPLACED SSH-SIGNER2.VUI SSH-062_A044 22-NOV-2003
>>XREPLACED SSH2.VUI SSH-062_A044 22-NOV-2003
>>XREPLACED SSHD.VUI SSH-062_A044 22-NOV-2003
>>XREPLACED SSHD2.VUI SSH-062_A044 22-NOV-2003
>>XREPLACED SSHD2_CONFIG_TEMPLATE.VUF SSH-062_A044
>>22-NOV-2003
>>XREPLACED SSHD_MASTER.VUI SSH-062_A044 22-NOV-2003
>>XREPLACED SSHLEI.VUI SSH-062_A044 22-NOV-2003
>>XREPLACED SSHREGEX_TXT.VUF SSH-062_A044 22-NOV-2003
>>XREPLACED START_SSH_COM.VUF SSH-062_A044 22-NOV-2003
>>XREPLACED UNLOAD_SSHLEI.VUI SSH-062_A044 22-NOV-2003
>>XREPLACED USER_CLD.VUF SSH-062_A044 22-NOV-2003
>>XREPLACED MULTINET_STREAM_SYMBIONT.VUI
>>STREAMSYMB-050_A044 22-NOV-2003
>>XREPLACED UCXDRIVER.VUI UCXDRIVER-030_A044 22-NOV-2003
>>XREPLACED UCX$IPC_SHR.VUI
>>UCX_LIBRARY_EMULATION-021_A044 22-NOV-2003
>>

>
>Jim Mehlhop
>
>
>Join Cauce to outlaw spam
>http://www.cauce.org/
>