cancel
Showing results for 
Search instead for 
Did you mean: 

connect to Oracle is slow!

ckchoi
Advisor

connect to Oracle is slow!

Dear all,

I found that it's quite slow when I connect to Oracle. Usually, what's the reason for that and how can I improve?

I found that CPU and memory of our Unix machine are in comfortable level.
5 REPLIES
A. Clay Stephenson
Acclaimed Contributor

Re: connect to Oracle is slow!

Ask yourself could you diagnose the problem with so little data? Is this a local connection to the database or is it a network connection? If network, the first thing I would look at is hostname resolution.
If it ain't broke, I can fix that.
ckchoi
Advisor

Re: connect to Oracle is slow!

It's a local connection.
ckchoi
Advisor

Re: connect to Oracle is slow!

It seems that there's some runaway processes which cause the performance problem. After rebooting the machine, the problem was solved.

Anyway, thanks for your help.
Sunil Kumar MK
Occasional Advisor

Re: connect to Oracle is slow!

Hi Ckchoi,

If it is a local database and if you are using TNS service names to connect to the database, you can further improve the performance by using IPC cpnnections instead of TCP protocol.

Regards
Sunil
Yogeeraj_1
Honored Contributor

Re: connect to Oracle is slow!

hi ckchoi,

can you please confirm the tool that you are using to connect?

also, can you confirm the Oracle database version you are connecting to?

thanks
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)