OraFAQ Forum: Performance Tuning » Queries perform slow

Home » RDBMS Server » Performance Tuning » Queries perform slow

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

Queries perform slow [message #170792]

Fri, 05 May 2006 03:09

milind_sri
Messages: 70
Registered: February 2005
Location: Pune

Member

Hi Gurus,

I have these three queries which are taking 3.5 minutes to execute on production. I came to know that in the morning these queries take few seconds to execute and as the day goes on the queries becomes slow. I dont know what may be the reason behind this. I have to suggest the way out so that this kind of behaviour can be avoided and the queries perform in the same way as they perform in the morning.

Please help me out and suggest the way out so that the queries perform better in the morning as well as late in the day.

Thanks in Advance.

Milind.

Attachment: Queries.txt
(Size: 14.00KB, Downloaded 1410 times)

Report message to a moderator

Re: Queries perform slow [message #170793 is a reply to message #170792]

Fri, 05 May 2006 03:15

Frank
Messages: 7901
Registered: March 2000

Senior Member

Quote:

--- Applying the filters
and W.ASSIGNED_TO = '1132' and
TRUNC(W.RECEIVED_DATE) BETWEEN '26-Apr-2005' and '26-Apr-2006' and
B.ENTITY_ID = 2142500004 and exists

Oh my god.
No binds, dates compared to strings.
Ever read/followed AskTom?
Look there for reasons behind bind-variables.

Report message to a moderator

Previous Topic:	Query Slow - any ideas how to speed it up??? here's what I have...
Next Topic:	ip address

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 01 08:51:25 CDT 2025