Re: Fast vs Pipes and TCP/IP (speeds up Oracle)
Date: 1996/07/08
Message-ID: <4rppjh$r5g_at_inet-nntp-gw-1.us.oracle.com>#1/1
In <31DA4C42.16B5_at_psx.ch.sni.be> JF DENIS <jf.denis_at_psx.ch.sni.be> writes:
} Hello,
} Oracle allows to use different types of two-task modes: Pipes (P:),
} TCP/IP (T:) and Fast (F:).
} This last one seems to bring many advantages as it uses shared memory
} and semaph. for the communication and by this way can speed up Oracle
} (says the Oracle book).
Well, we *wanted* it to be faster. It turns out that the "Fast" driver isn't. Unix vendors have done a pretty good job optimizing Unix pipes and TCP/IP, and the "Fast" driver consistantly lost out to the Pipes driver in benchmarking situations.
} replacing P: by F: gives the Oracle error ORA-03106
[snip]
} (we use Oracle 7.0.15on a Unix box).
As a result of the performance problems I mentioned, the "Fast" driver was dropped from the V7 bundle. The error you're getting means that the client can't talk to the server.
Note that all the drivers you mention above are V1 drivers, and are replaced by V2 adaptors in later versions of Oracle.
-p
Paul Zola Technical Specialist World-Wide Technical Support
GCS H--- s:++ g++ au+ !a w+ v++ C+++ UAV++$ UUOC+++$ UHS++++$ P+>++ E-- N++ n+
W+(++)$ M+ V- po- Y+ !5 !j R- G? !tv b++(+++) !D B-- e++ u** h f-->+ r*
Disclaimer: Opinions and statements are mine, and do not necessarily reflect the opinions of Oracle Corporation.Received on Mon Jul 08 1996 - 00:00:00 CEST