Re: IPC versus TCP performance

clearly i am a bit late to thus conversation.

nonetheless you may find this interesting

https://www.freelists.org/post/oracle-l/IPC-vs-TCP

On Tue, Oct 30, 2018 at 06:03 Hameed, Amir <Amir.Hameed_at_xerox.com> wrote:

> Hi,
>
> I have two databases running on the same physical server. The OS is RHEL7.
> Database *A* is 11.2.0.4 and is running as Active Data Guard. Database *B*
> is a reporting database and is version 12.1.0.2. In the past, database *A*
> was running on Solaris (four-node RAC) and we were using Oracle Streams to
> replicate over 400 tables from this particular database over to database
> *B*. We were also replicating tables from multiple other databases to
> database *B* but that is beside the point for this discussion. After we
> converted database *A* to LINUX, we decided to keep database *B* as the
> front-end and created synonyms to access tables from database *A* (ADG)
> using DB links. We have also setup IPC communication between A and B
> assuming that IPC would be faster than TCP. Unless I have misconfigured
> IPC, so far the performance of accessing database from B-to-A over a DB
> link is abysmal. Before I ask users to start accessing A directly instead
> of going through B, I wanted to understand the IPC communication a bit
> better.
>
>
>
> In my scenario where both databases reside on the same physical server, is
> there a way to optimize access from B-to-A over a DB link?
>
>
>
> Thank you,
>
> Amir
>
>
>
>
>

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Principal Consultant at Pythian
Pythian Blog http://www.pythian.com/blog/author/still/
Github: https://github.com/jkstill

--
http://www.freelists.org/webpage/oracle-l