Ask the Expert

Why is dblink between two instances on same platform slow?

I am trying to determine why a database link between two instances on the same platform is extremely slow as compared to a link to a remote database. I have set the listener and tnsnames to use IPC, but it does not resolve the issue.

    Requires Free Membership to View

IPC should be faster than TCP/IP for communicating with two databases on the same server. The only real way to find out what is causing your problems is to generate a trace of your network traffic. This can be done by adding the following lines to your SQLNET.ORA file:

trace_level_client=support
trace_file_client=cli
trace_directory_client=/my_oracle_home/network/trace
trace_unique_client=true
Then start your process which uses the database link. After that is done, comment out or remove those lines from your SQLNET.ORA file to stop further trace files from being generated.

Now examine the contents of $ORACLE_HOME/network/trace. You'll need to look in the trace files to determine which one was generated by your specific session. This can be done quite easily by using grep on your SQL statements.

Once you have identified the trace file, you'll want to open a TAR with Oracle Support. They can best analyze the contents of your trace file and help you sort out your difficulties.

For More Information


This was first published in August 2002

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: