OraFAQ Forum: Performance Tuning » sql query performance guide

Home » RDBMS Server » Performance Tuning » sql query performance guide (Oracle 11.2.4.0 , SunOS)

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

sql query performance guide [message #622165]

Fri, 22 August 2014 00:20

mc1825263
Messages: 7
Registered: August 2014
Location: india

Junior Member

Hi,

When i see sql query is running for long time than expected time in order to get help from you , what are the steps i need to provide you to make your findings easier ?

Regds,
mc

Report message to a moderator

Re: sql query performance guide [message #622168 is a reply to message #622165]

Fri, 22 August 2014 00:58

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You can first read:
- OraFAQ Forum Guide, Detailed OraFAQ Forum Guide section, Performance Tuning paragraph
- 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.

[Updated on: Fri, 22 August 2014 01:21]

Report message to a moderator

Re: sql query performance guide [message #622169 is a reply to message #622168]

Fri, 22 August 2014 01:00

mc1825263
Messages: 7
Registered: August 2014
Location: india

Junior Member

Thanks a lot Michel

Report message to a moderator

Previous Topic:	explain plan details vary between display & display_cursor
Next Topic:	Update non-token column on compressed table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 18:22:04 CST 2025