Oracle 8i login is very slow

Hi all,

I have two Windows 2000 Servers:
1. Compaq Server with one 2.4G CPU, 1G RAM and 30G harddisk 2. Acer Server with one 2.4G CPU, 1G RAM and 30G harddisk

The software configuration of two server are identical, they both have:
1 Windows 2000 Server with SP3
2 Oracle 8i ( Oracle configuration(such SGA, buffer size, etc...) are also identical

But I found two strange things I cannot explain.

1.)
When I local(not throuhg network) login Oracle on Compaq Server, it only takes no more than 1second to login. But When I local login Oracle on Acer Server it takes about 3 seconds to logon.

2.)
I local login to Oracle on Acer Server, and followed by executing a query which involves external procedure call, it takes 5 seconds to finish that query. In the same session, I executed the same query again and again, it only took 2 seconds to complete. I donot know why the first execution of a query (with external procedure call) takes longer time. It seems Oracle takes some time to load the external procedure service in Acer server. Again the strange thing, there is not such issue in Compaq Server, no matter when I execute the same query, it always take 2 seconds.

Could any one tell me why Oracle on Acer Server has slow response in certain situations (e.g Logon , and run first query involve external procedure). And any solution to solve the problem?

Thanks in advance.

John Received on Sat Apr 12 2003 - 05:12:43 CDT