OraFAQ Forum: Server Administration » Query Performance issues...

Home » RDBMS Server » Server Administration » Query Performance issues...

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Query Performance issues... [message #54748]

Tue, 03 December 2002 00:56

Jaco
Messages: 23
Registered: August 2000

Junior Member

Hi there,

We are having some performance issues when some customers query our database via the extranet, but one customer especially is having trouble. The way it works is that a customer logs in on the extranet, does a couple of queries and then logs out. The info is then displayed on the customer's screen. We have traced the problem to be at the back-end (When the querying starts on the database until it ends). Sometimes the same operation takes 3seconds and sometimes it takes 3 minutes! I have done traces of the user's session and compared it with another user's session that is not having the troubles, and can see nothing out of the ordinary, The only difference is that user A(with the problems) is doing these queries much more than any of the other users.
Why is the preformance not consistant?

Any help will be appreciated.
Thnx,
Jaco

Report message to a moderator

Re: Query Performance issues... [message #54749 is a reply to message #54748]

Tue, 03 December 2002 00:58

Jaco
Messages: 23
Registered: August 2000

Junior Member

Forgot to add...
The users are using the same queries.

Report message to a moderator

Re: Query Performance issues... [message #54752 is a reply to message #54748]

Tue, 03 December 2002 02:16

psmyth
Messages: 81
Registered: October 2002

Member

Is the problem apparent when the user is logged into a different PC? My first impression is that you may have a non-oracle issue here.

Report message to a moderator

Re: Query Performance issues... [message #54896 is a reply to message #54748]

Fri, 13 December 2002 13:30

Jay Johnson
Messages: 1
Registered: December 2002

Junior Member

In reading the original post, this sounds very similar to what we are experiencing as well. The only difference is that we are internal users only. They are hitting a Red Hat Server on 8.1.7.1 through a novell network with IP. We have been searching for a solution for weeks and have not found anything. Any input would be greatly appreciated.

-JT

Report message to a moderator

Previous Topic:	should not perform any Db operation on SAT , SUNDAY ....
Next Topic:	Can I set a massive delete transaction not use roll back segment

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 28 08:16:20 CDT 2025