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 .

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.