Home » RDBMS Server » Performance Tuning » Performance degrade (Oracle 11gr2 , linux AS5)
Performance degrade [message #601644] Sat, 23 November 2013 11:57 Go to next message
oradba123
Messages: 71
Registered: June 2009
Location: india
Member

Hi all,

SQL query which is fetching data from five tables in Oracle 11.2.0.1.0 on Linux 5 , taking double of the time to fetch the data before it used to take, i have gathered statistics of all tables by seeing the view dba_tab_statistics under that column stale_statistics , but no affect or impact of that, so could any one suggest me how to tune the SQL query step by step. i would appreciate a lot.

Thanks & Regards.
Re: Performance degrade [message #601645 is a reply to message #601644] Sat, 23 November 2013 12:04 Go to previous messageGo to next message
BlackSwan
Messages: 22554
Registered: January 2009
Senior Member
http://www.orafaq.com/forum/m/433888/136107/#msg_433888
Please refer to URL above & be sure to provide the details requested:
1) DDL for all tables & indexes
2) EXPLAIN PLAN
3) output from SQL_TRACE & tkprof
Re: Performance degrade [message #601646 is a reply to message #601645] Sat, 23 November 2013 12:28 Go to previous messageGo to next message
John Watson
Messages: 4411
Registered: January 2010
Location: Global Village
Senior Member
I don't think that link is correct? Try
http://www.orafaq.com/forum/m/433888/#msg_433888
Re: Performance degrade [message #601852 is a reply to message #601646] Tue, 26 November 2013 08:08 Go to previous message
Kevin Meade
Messages: 1934
Registered: December 1999
Location: Connecticut USA
Senior Member
1. post the query. do you really think anyone can tune a query without actually seeing the query.

2. post the before and after query plans and runtimes

This will be a start. IF anyone decides to pick this up, they will likely ask for more of whatever they think they need.

good luck
Previous Topic: fast query
Next Topic: Need help in tuning query
Goto Forum:
  


Current Time: Fri Aug 01 01:28:38 CDT 2014

Total time taken to generate the page: 0.06337 seconds