Re: Performance

Hi:

1. Do a PING to your server to see what kind of network response you get. If you get packets back within 10-20 ms, then the network's probably not the problem. If you get packets back in 500+ ms, then the network might be the issue.
2. See how long a TNSPING takes compared to the PING. If the TNSPING is just a little longer than the PING, good so far. If the TNSPING is much longer, this indicates that something with the TNSListener is not configured correctly.
3. If you have a huge number of roles enabled, this can take a bit on an overworked database.

My best guess is that, most likely, you have multiple protocols or aliases defined in either your TNSNAMES.ora file or your LISTENER.ora file (most likely, TNSNAMES.ora). Put the protocol and alias that you want to use most often at the top of both files. This way, you avoid network timeouts from trying to connect to non-existent or unreachable addresses.

Regards,

--
David C. Sisk
The Unofficial ORACLE on NT site
http://www.ipass.net/~davesisk/oont.htm

Nilo P.A. Cabrera wrote in message <378F77B9.E846C787_at_wtp.net>...
>I am have a problem with performance:
>Connecting/disconnecting to and from the database
>takes to long. 8-10 seconds. Even when working
>directly on the system console.
>
>Working with Oracle 7.3.3, 128MB ram
>dual pentiums, SCO Openserver 5.
>
>Any suggestions
>
>
>Nilo
>
Received on Sun Jul 18 1999 - 18:52:50 CDT