database procedure slow in running from unix client

From: Glenn MacKay <glen_mackay_at_yahoo.com>
Date: 14 May 2002 06:50:34 -0700
Message-ID: <831d3f98.0205140550.2f525810_at_posting.google.com>

We are running an Oracle 8.1.7 database on a Windows NT machine. When we run a particular stored procedure through SQL*PLUS on a UNIX machine the procedure is very slow in running. This same procedure, when run through a Windows NT client is extremely fast.

The UNIX machine that we run the procedure on has its own Oracle 8.1.7 database although we are using a database link to connect our UNIX client to the NT Oracle server.

My question is why the discrepancy in performance? The procedure is running on the database in both cases. I'm kind of new at this and am somewhat perplexed. Any help would be appreciated. Thanks Received on Tue May 14 2002 - 15:50:34 CEST

This message: [ Message body ]
Next message: Alex: "Weekly number of trades"
Previous message: John Schluter: "Looking for Rochade users"
Next in thread: Burt Peltier: "Re: database procedure slow in running from unix client"
Reply: Burt Peltier: "Re: database procedure slow in running from unix client"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message