Home » RDBMS Server » Performance Tuning » Query running slow .. a day before it was fine
icon4.gif  Query running slow .. a day before it was fine [message #261493] Wed, 22 August 2007 15:27 Go to next message
luckyally
Messages: 16
Registered: August 2007
Location: Hyderabad
Junior Member

A query use to run fine every day .. even yesterday it was working fine... today user complains query is running very slow.. what steps are to be taken to troubleshoot this ..

Thanks in advance..
Re: Query running slow .. a day before it was fine [message #261498 is a reply to message #261493] Wed, 22 August 2007 15:54 Go to previous messageGo to next message
BlackSwan
Messages: 25032
Registered: January 2009
Location: SoCal
Senior Member
>what steps are to be taken to troubleshoot this ..
Other than reading & following the advice in the STICKY posts at the top of this forum, you could stop random folks on the street & ask them what they would do.
Re: Query running slow .. a day before it was fine [message #261642 is a reply to message #261493] Thu, 23 August 2007 03:33 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
If the folks on the street can't help, you may want to check if statistics were recently updated.
Re: Query running slow .. a day before it was fine [message #264303 is a reply to message #261642] Sun, 02 September 2007 23:55 Go to previous messageGo to next message
luckyally
Messages: 16
Registered: August 2007
Location: Hyderabad
Junior Member

Can some one help me on this issue..

if not the details how to go about troubleshooting...at least some basic things i need to follow.

Its not that i am asking with out studying the subject. i have studied many topics.. i am not sure where to start from


Shall i use sqltrace and trprof to determine what is going wrong..
or
Shall i use explain plan ....

how should i approach to find a solution for this ...


Re: Query running slow .. a day before it was fine [message #264305 is a reply to message #264303] Mon, 03 September 2007 00:01 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
Maybe you didn't hear 1st time.
READ THE STICKY
Re: Query running slow .. a day before it was fine [message #265490 is a reply to message #261493] Thu, 06 September 2007 07:30 Go to previous messageGo to next message
jai_subi
Messages: 7
Registered: May 2007
Location: Chennai
Junior Member
check the volume of the data.
Analyze the tables.
create index, if required.
analyze the indexes, if it was there.
check the cost of execution plan.



Re: Query running slow .. a day before it was fine [message #265501 is a reply to message #265490] Thu, 06 September 2007 08:01 Go to previous messageGo to next message
mson77
Messages: 208
Registered: August 2007
Location: Brazil
Senior Member
Hello luckyally,

avoid people joking of you.
Follow the recommendation of this helping house.

The first step... to people in this welcoming house is:
==> read the initial yellow sticky.
http://www.orafaq.com/forum/t/88153/0/

There you will read all the sense guidelines... and one and first item is: "How to get a quick answer to your question?" (maybe this is what you want).

Sincerely... I was reading your thread from the starting...but you didn't post any technical information here. If I ask to you... "my production query got slow"... were you able to guide me?

I believe that all of us wants to help you... but the first step to accomplish this is: "You have to be able to help you too!"
Post here information... post here your experiments... your tests.

Regards,


mson77
Re: Query running slow .. a day before it was fine [message #266505 is a reply to message #261493] Tue, 11 September 2007 01:16 Go to previous messageGo to next message
rupaliss
Messages: 6
Registered: July 2007
Location: Mumbai
Junior Member

Hi,

I have SAP R/3 4.7 on HP-UX 11.23 & Oracle 9i. Users are facing slow performance issues while working on these SAP servers...what are the checks at the Oracle Database level, if there is any tuning can be done to improve the overall performance. Please Help.

Thanx
Rupali S
Re: Query running slow .. a day before it was fine [message #266509 is a reply to message #261493] Tue, 11 September 2007 01:26 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

rupaliss is analogous to luckyally.
To rupaliss review this topic.
Follow Sticky.

Previous Topic: Too many redo log file (merged)
Next Topic: CPU usage has been 100% consistently
Goto Forum:
  


Current Time: Fri Dec 02 12:04:49 CST 2016

Total time taken to generate the page: 0.06905 seconds