Home » RDBMS Server » Performance Tuning » tuning basics (Oracle 10g)
tuning basics [message #629594] Thu, 11 December 2014 11:29 Go to next message
m.abdulhaq
Messages: 254
Registered: April 2013
Location: Ajman
Senior Member
hi experts , kindly suggest me how can i gain more knowledge on performance tuning as i have to fine tune , lot of long running queries in my database.Do i need to start from Database concepts , then performance tuning guide .
Re: tuning basics [message #629595 is a reply to message #629594] Thu, 11 December 2014 11:31 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Do i need to start from Database concepts , then performance tuning guide .
YES!

See first post in TUNING subforum here.
Re: tuning basics [message #629630 is a reply to message #629595] Fri, 12 December 2014 10:39 Go to previous messageGo to next message
m.abdulhaq
Messages: 254
Registered: April 2013
Location: Ajman
Senior Member
thanks blackswan.
Re: tuning basics [message #629638 is a reply to message #629630] Fri, 12 December 2014 16:23 Go to previous message
Kevin Meade
Messages: 2103
Registered: December 1999
Location: Connecticut USA
Senior Member
If what you are looking for is SQL Tuning, then attached is the first chapter of my book on SQL Tuning. This is the promotional chapter, but it is the full chapter so you can learn about the FRP method of Cardinality Based Tuning. The scripts from the book are also free regardless of if have the book or not, and can be downloaded from here.

If you like what you read, you can buy the book at a discount because you are a member of ORAFAQ. The link shows the 50% off coupon code but through end of December, you can also use this 60% off code. These codes are only good on the CREATESPACE website.

ZK9SXEMX	Percentage Off	60%

To be clear, the first chapter and the scripts are free. You do not have to purchase the book to take them.

Enjoy. Kevin Meade

[Updated on: Mon, 05 January 2015 16:55]

Report message to a moderator

Previous Topic: performance issue with sql query in UAT, But good in local
Next Topic: Remote query performance in BO reports
Goto Forum:
  


Current Time: Sat Nov 23 18:19:30 CST 2024