Hi All,
I am given chance to pick up some books on performance tuning for our company.
Please suggest me some good books ( i mean the authors ).
Thanks
Abhay.
Printable View
Hi All,
I am given chance to pick up some books on performance tuning for our company.
Please suggest me some good books ( i mean the authors ).
Thanks
Abhay.
Hi Abhay
0)Oracle tuning 101 by keerti deshpande and gaja vaidyanatha
1)Guy Harrison who comes at the top of my mind
2)Mark Gurry is obviosly the second choice
3)Tom Kyte he is also very good
4)Don Burelson
5)Ahmed Almori Unix specific
also i kniow of christopher long here at www.dbasupport.com who was supposed to write a book..dont know wheather it is out
regards
Hrishy
Guy Harrison should be okay to buy right?
Mind i dont have a bit of knowledge about these authors.
I go with you by what u say.
Thanks
Abhay.
Hi
Yes Guy as well as Mark Gurry both are cool..
regards
Hrishy
I found Rich Niemiec's 'Oracle Performance Tuning' a good help. Very good on explaining the basic concepts then delving deep into then detail. Also VERY, VERY good were the sections in Tom Kyte's (brilliant)'Expert One-on-One Oracle'
Thanks
Abhay.
Guy Harrison also has some free, basic tools:
http://home.pacific.net.au/~gharriso/
Hrishy, JMac, Dapi.
Please also suggest some books on Database Architechure & PL/SQL.
Our company wants to buy books in bulk.
thanks for ur help
Abhay.
Oracle PL/SQL Programming by Steve Feurstein and Bill Pribyl(O'Reilly) is excellent.
thanks for reply.Quote:
Originally posted by hacketta
Oracle PL/SQL Programming by Steve Feurstein and Bill Pribyl(O'Reilly) is excellent.
Steve Feurstein and Bill Pribyl (O'Reilly) are 2 authors of 1 book?
or the other way...diff authors for 2 diff books?
Please dont mind, i really dont have bit of knowledge about books and authors.
Abhay.
Sorry, my do-it-and-then-lookup-the-error-message method of programming won't be what you want! I use Scott Urman's Oracle Press book as a PL/SQL reference.
For DB architecture - well, my first lessons were at the feet of a master, after that any books were an anticlimax. My recommendation would be to find something strong on Entity-Relationship modeling. IMHO if you get the E-R model right, the rest should follow. E-R models have two important merits:
1) An intelligent user can understand them and therefore they can be used as tools for analysis.
2) If the E-R is good, the normalisation looks after itself (mostly).
The Art of Computer Systems Performance Analysis : Techniques for Experimental Design, Measurement, Simulation, and Modeling
- RAJ JAIN
http://www.amazon.com/exec/obidos/tg...0768?vi=glance
The best book in market for system performance analysis...
This one is not on oracle but gives the over all system performance tuning concepts...
If you company is buying in bundles you can ask for this one too, its quite costly...
A very old book but still referred by many...
Mandatory.Quote:
Originally posted by hrishy
3)Tom Kyte he is also very good
Quote:
4)Don Burelson
One caveat about his statspack book. Good if you want to write your own statspack reports. Not so good explaining the default report.
Mandatory reading for Oracle on Unix.Quote:
5)Ahmed Almori Unix specific
Thanks for the plug, Hrishy, but no, I never finished the book. I'm stuck at around 230 pages right now and have been for a while. I refuse to say it's dead but it is on life-support :(.
As for Niemic's book, that's one I'd stay far away from, at least for its SQL and PL/SQL content, which is practially worthless. The DBA stuff may be fine, but that's not my expertise, so I can't judge, but I'd say the odds are against it.
- Chris
Well i find Jonathan Lewis "Practical Oracle 8i" good enough. Thats one more book you should have in your bookshelf other than "Expert One on One Oracle", "SQL High Performance Tuning"
And to be honest i never manage to finish a book front to back... Mostly use them for references.
I would however recommend to curl up in an armchair (winter) or hammock (summer) and look at (not read) every page - that way you know what is possible, even if you can never remember how to do it. (This I find is the advantage of paper over html or pdf - they either put me to sleep or give me a headache!)Quote:
Originally posted by adewri
And to be honest i never manage to finish a book front to back... Mostly use them for references.
Don't wory, Chris, the DBA stuff in that book is even worse, IMHO. I've already ranted about Niemic's book in this forum couple of times and I'll say it again: by far the worst book about Oracle tuning I came accross!Quote:
Originally posted by chrisrlong
As for Niemic's book, that's one I'd stay far away from, at least for its SQL and PL/SQL content, which is practially worthless. The DBA stuff may be fine, but that's not my expertise, so I can't judge, but I'd say the odds are against it.
Sorry for the late reply. Oracle PL/SQL Programming is one book witten by two authors (Feurstein and Pribyl).
If I were you I'd listen to steve adams.......
http://www.ixora.com.au/resources/
You can just buy all of these and you'll be very happy.
Steven's book is good but you must have pl/sql &suppl.packages pdf's alongside.
Steve Adams book "Oracle8i Internal Services" is mere 100 pages but the contents are too heavy. An excellent book for oracle internals.Quote:
Originally posted by Tarry
If I were you I'd listen to steve adams.......
http://www.ixora.com.au/resources/
You can just buy all of these and you'll be very happy.
Steven's book is good but you must have pl/sql &suppl.packages pdf's alongside.
Waiting for Wrox Publishers book on P&T by Tom Kyte. Will it ever get published being wrox publishers down the tubes...
All the book selling sites says it will be published this month and in Wrox site I can't even find that book exists in real/virtual world
Latest news is that TOM has signed up with Oracle press and book should be out by summer end.Quote:
Originally posted by sreddy
Waiting for Wrox Publishers book on P&T by Tom Kyte. Will it ever get published being wrox publishers down the tubes...
All the book selling sites says it will be published this month and in Wrox site I can't even find that book exists in real/virtual world
that'll add $30 to the price then
Same Book(due from Wrox) with Oracle Press OR its gonna be different book ?Quote:
Originally posted by adewri
Latest news is that TOM has signed up with Oracle press and book should be out by summer end.
Anyway, I hate presentation of Oracle Press books..
Right from the horses mouth :)Quote:
Originally posted by sreddy
Same Book(due from Wrox) with Oracle Press OR its gonna be different book ?
Anyway, I hate presentation of Oracle Press books..
http://asktom.oracle.com/pls/ask/f?p...145042756282,Y
from these posts, what books do the below two wrote?
1) Ahmed Almori Unix specific
2) Tom Kyte he is also very good
;) Can't you go to amazon.com and search on Author and title.
Obviously they write only one book with specific title right ?
Must've been some real smart dude who started that hottest thread at tom's site :D :)Quote:
Originally posted by adewri
Right from the horses mouth :)
http://asktom.oracle.com/pls/ask/f?p...145042756282,Y
But seriously I can't stand the oracle press books. It's a shame that wrox went down(I liked the whole thing red/yellow,the girth etc), O'reilly was also a good option.
Yes Yes, Very Smart :D and i think i know him don't i.Quote:
Originally posted by Tarry
Must've been some real smart dude who started that hottest thread at tom's site :D :)
Thanks to all of u guys.
Abhay.
Ahum..:DQuote:
Originally posted by adewri
Yes Yes, Very Smart :D and i think i know him don't i.