Home » RDBMS Server » Performance Tuning » sql query performance guide (Oracle 11.2.4.0 , SunOS)
sql query performance guide [message #622165] Fri, 22 August 2014 00:20 Go to next message
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
Re: sql query performance guide [message #622168 is a reply to message #622165] Fri, 22 August 2014 00:58 Go to previous messageGo to next message
Michel Cadot
Messages: 65377
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous message
mc1825263
Messages: 7
Registered: August 2014
Location: india
Junior Member
Thanks a lot Michel
Previous Topic: explain plan details vary between display & display_cursor
Next Topic: Update non-token column on compressed table
Goto Forum:
  


Current Time: Sat Feb 17 16:24:51 CST 2018

Total time taken to generate the page: 0.06902 seconds