OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » Tuning issue (Oracle 10.0.2.1)

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

Tuning issue [message #565820]

Thu, 06 September 2012 19:20

arif_md2009
Messages: 677
Registered: May 2009
Location: United Arab Emirates

Senior Member

i have a report in 6i based on multi data links and each table has a index field referenced in where clause but its taking long time for the report to open, how do i need to fine tune it , i am very new to tuning and i have no idea where to start from.Can anyone suggest me where do i need to start from , i know there are lot of references on this website to read but i need to get on hands on quicker .

Report message to a moderator

Re: Tuning issue [message #565821 is a reply to message #565820]

Thu, 06 September 2012 19:26

BlackSwan
Messages: 20085
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

Report message to a moderator

Re: Tuning issue [message #565827 is a reply to message #565820]

Thu, 06 September 2012 23:55

Michel Cadot
Messages: 54126
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

You can first read:
- Performances Tuning sticky
- OraFAQ Performance Tuning
- Rosco's SQL Tuning Guide
- Tuning High-Volume SQL Wiki page

You can also have a look at Database Performance Tuning Guide.

Regards
Michel

[Updated on: Thu, 06 September 2012 23:55]

Report message to a moderator

Re: Tuning issue [message #565934 is a reply to message #565821]

Sat, 08 September 2012 16:34

arif_md2009
Messages: 677
Registered: May 2009
Location: United Arab Emirates

Senior Member

thanks

Report message to a moderator

Re: Tuning issue [message #565935 is a reply to message #565827]

Sat, 08 September 2012 16:36

arif_md2009
Messages: 677
Registered: May 2009
Location: United Arab Emirates

Senior Member

thanks michel, i tried to start with indexing, there is an improvement, i did indexing based on the where clause of my select statement.

[Updated on: Sat, 08 September 2012 16:37]

Report message to a moderator

Previous Topic:	Explain plan of a query
Next Topic:	tuning stats command

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 18 15:21:58 CDT 2013

Total time taken to generate the page: 0.32515 seconds