Home » RDBMS Server » Networking and Gateways » query speed
query speed [message #66231] Mon, 11 February 2002 06:20 Go to next message
Messages: 15
Registered: November 2001
Junior Member

My company recently upgraded the network system and a 5 minutes query before runs for an hour now. I think it's the firewall thing on out LAN but no idea how to fix it. Anyone has any clue?

Re: query speed [message #66232 is a reply to message #66231] Mon, 11 February 2002 08:37 Go to previous message
Sreenivasan Balaji
Messages: 5
Registered: February 2002
Junior Member

You must first test the network speed with
utilities such as 'snoop'. You need to measure the incoming and outgoing speed of the packets.(assuming that you are using Oracle on UNIX and TCP)
Check if port#1521 is loaded with heavy packet
traffic. If port# 1521 is overloaded, try using
another port for this query.

Next check to see if you are using any database links in your query. This can slow you down.
You may have to localize the remote tables.

Check if the Query itself can be run using a
stored proc on the server side if its not already
in a stored proc.

Lastly, if you are using a middleware such as ODBC or JDBC try usng a different driver.

let me know if this helped.

Previous Topic: "lsnrctl status " is not recognized....URGENT,URGENT......
Next Topic: connectivity
Goto Forum:

Current Time: Thu Feb 22 01:50:40 CST 2024