Home » SQL & PL/SQL » SQL & PL/SQL » 10g Performance Tuning Book
10g Performance Tuning Book [message #317139] Tue, 29 April 2008 12:23 Go to next message
Kaeluan
Messages: 179
Registered: May 2005
Location: Montreal, Quebec
Senior Member
Hello,

anyone have a good book about SQL/PLSQL Performance Tuning for 10g database to suggest?

I found this one
Oracle Database 10g Performance Tuning Tips & Techniques
by Richard Niemiec

But i want to know if anyone have another good book to suggest or recommand ?

Thank you
Re: 10g Performance Tuning Book [message #317144 is a reply to message #317139] Tue, 29 April 2008 12:29 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can first read:
- OraFAQ Forum Guide, Performance Tuning section
- How to Identify Performance Problem and Bottleneck
- OraFAQ Performance Tuning
- Rosco's SQL Tuning Guide

You can also have a look at Database Performance Tuning Guide.

Regards
Michel
Re: 10g Performance Tuning Book [message #317148 is a reply to message #317139] Tue, 29 April 2008 12:37 Go to previous messageGo to next message
Kaeluan
Messages: 179
Registered: May 2005
Location: Montreal, Quebec
Senior Member
Thank Michel,

I agree that those links are probably the best and i am already using them, but some peoples where i am working want to buy a book instead of reading over the web and i was wandering if there is some better book than the one I specified in the original post.

Regards,

Re: 10g Performance Tuning Book [message #317149 is a reply to message #317139] Tue, 29 April 2008 12:48 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
Optimizing Oracle Performance
by Cary Millsap , Jeffrey Holt
# Paperback: 388 pages
# Publisher: O'Reilly Media, Inc. (September 16, 2003)
# Language: English
# ISBN-10: 059600527X
# ISBN-13: 978-0596005276

HIGHLY recommended!
Re: 10g Performance Tuning Book [message #317150 is a reply to message #317148] Tue, 29 April 2008 12:48 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Just my opinion but if you want to design and develop an efficient application, the best is to start with:
The Art of SQL, Stephane Faroult, ISBN 10: 0-596-00894-5 | ISBN 13: 9780596008949
Effective Oracle by Design, Tom Kyte

Now it depends on what you mean with "tuning".

Regards
Michel

[Updated on: Wed, 05 May 2010 10:14]

Report message to a moderator

Re: 10g Performance Tuning Book [message #317154 is a reply to message #317139] Tue, 29 April 2008 13:02 Go to previous message
Kaeluan
Messages: 179
Registered: May 2005
Location: Montreal, Quebec
Senior Member
Thank Michel and Anacedent,
I will suggest those books and will send the link to Tuning forum to others developper where i am working so they can go check for solution if they have another performance problem.

Regards,

[Updated on: Tue, 29 April 2008 13:02]

Report message to a moderator

Previous Topic: How to handle multiple Application env which uses single database
Next Topic: Design Document for stored procedure
Goto Forum:
  


Current Time: Thu Dec 08 08:19:48 CST 2016

Total time taken to generate the page: 0.12759 seconds