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