Check your sqlnet.ora on both machines. I suspect they are not identical.
Regards
HJR
"Frank Y" <zafemail_john_at_yahoo.com> wrote in message
news:2fcf2d80.0304120212.46794e29_at_posting.google.com...
> 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 - 07:01:00 CDT
