Home » RDBMS Server » Performance Tuning » Tuning issue (Oracle 10.0.2.1)
Tuning issue [message #565820] Thu, 06 September 2012 19:20 Go to next message
arif_md2009
Messages: 732
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 .
Re: Tuning issue [message #565821 is a reply to message #565820] Thu, 06 September 2012 19:26 Go to previous messageGo to next message
BlackSwan
Messages: 23151
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: Tuning issue [message #565827 is a reply to message #565820] Thu, 06 September 2012 23:55 Go to previous messageGo to next message
Michel Cadot
Messages: 59997
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 Go to previous messageGo to next message
arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates
Senior Member

thanks
Re: Tuning issue [message #565935 is a reply to message #565827] Sat, 08 September 2012 16:36 Go to previous message
arif_md2009
Messages: 732
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:
  


Current Time: Sat Dec 20 08:05:05 CST 2014

Total time taken to generate the page: 0.10721 seconds