iam new in performance tuning .....

Replies to This Discussion

Permalink Reply by Jesus Armand Calejero Roman on April 27, 2008 at 11:56am

Hello.

I am new in performance too. I read Oracle High Performance Turning for 9i and 10g (Powerll, ElSevier digital press). It's a good book but when we carrefully read and practice with the examples we find a lot of contradictations. I don't know if this is an author problem or if it happens in differents situatios (OS system, computer, different Oracle instalation process).

To start in performance I think that this book is perfect.

I have three presentations online to Oracle performance tuning (Indexes, tablespaces and tables). Link

Sorry but the powerpoints are in spanish

▶ Reply to This

Permalink Reply by Shadab on April 28, 2008 at 11:58pm

Hello....
thanks for ur reply...I will sure go through this book...rather i have oracle 10g R2 book....i will go through these books...
once again thnks for ur reply and for the material u shared with me but anyway If u have any presentation or any other material with examples that too in English then pls share with me..I am sure ur help will give me many ideas of Performance tuning and other DBA related activities.....

▶ Reply to This

Permalink Reply by TongucY on April 29, 2008 at 12:23pm

what about free and official books first?

choose your release and search for "2 Day + Performance Tuning Guide" and "Performance Tuning Guide" - http://tahiti.oracle.com/

▶ Reply to This

Permalink Reply by Ravi Prakash on July 24, 2008 at 9:03am

I go with Oracle Documentation which is always useful in many ways. Hope the below helps you as well.
1) http://download.oracle.com/docs/cd/B19306_01/server.102/b28051/toc.htm
2) http://download.oracle.com/docs/cd/B19306_01/server.102/b14211/toc.htm

Good Luck
Ravi Prakash
http://ravidba-oracle.blogspot.com/

▶ Reply to This

Permalink Reply by Srini on September 13, 2008 at 12:52am

Hi

In developer point of view, we can tune any query using explain plan. I found this is the easiest way to tune the query.

Steps:
1. Check the explain plan (Explain plan for seleect * from tab1,tab2 where tab1.id = tab2.id)
2. See what index has been used by each table.
3. If the query is using Range scan or full scan and huge data exists in the table. In this case you have to suppress the index untill table uses Unique index.


In oracle site you can find pdf's for peformance tunning.

Thanks
Srini.ik

▶ Reply to This