OraFAQ Forum: Performance Tuning » Performance degrade

Home » RDBMS Server » Performance Tuning » Performance degrade (Oracle 11gr2 , linux AS5)

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

Performance degrade [message #601644]

Sat, 23 November 2013 11:57

oradba123
Messages: 86
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.

Report message to a moderator

Re: Performance degrade [message #601645 is a reply to message #601644]

Sat, 23 November 2013 12:04

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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

Report message to a moderator

Re: Performance degrade [message #601646 is a reply to message #601645]

Sat, 23 November 2013 12:28

John Watson
Messages: 8870
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

Report message to a moderator

Re: Performance degrade [message #601852 is a reply to message #601646]

Tue, 26 November 2013 08:08

Kevin Meade
Messages: 2103
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

Report message to a moderator

Previous Topic:	fast query
Next Topic:	Need help in tuning query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Sep 24 10:57:14 CDT 2023