Re: distributed database performace issues across network

Maria wrote:

> Hi all
>
> I have recently configured a Oracle database server 8.1.7.4.0 on
> Solaris 5.8. I have created 2 instances each with 1 schema then I
> have created links to copy data across, then creates the indexes
> locally on the schema, the entire process is taking 2 hours, mean
> while I have 1 server with only 1 instance which has 2 schemas and the
> same process takes about 1 hour. The server configuration is the
> same the database configuration is the same and data as well, I even
> did a remote "create table as select * from ..." in between all
> instances and its all the same time expect when I came into the ONLY
> one instance and 2 schemas? can be that a distributed database link is
> taking double time to create table as select?
> Does any one came across this before? I called oracle support and they
> say yes its the link, I just can't believe that this can be double of
> time... Any ideas would be greatly appreciated
>
> Regards
> Maria

Reconfigure your SQL*Net to allow for IPC - I've seen it outperform TCP/IP 20-fold (AIX 4.3.3). Even bequeth should be possible, as you run on the same machine

-- 

Regards,
Frank van Bortel