↠´ Oracle9i Performance Tuning Tips & Techniques Ó Download by Ý Richard Niemiec
↠´ Oracle9i Performance Tuning Tips & Techniques Ó Download by Ý Richard Niemiec The author is obviously highly knowledgeable of Oracle He is, after all, an Oracle Certified Master, which is the highest level of Oracle certification requiring two days of intensive lab testing Most people fail to pass.
Overall the book is very well written and is full of useful knowledge I found its chapters on indexes, Oracle Enterprise Manager, and X tables as among the best I found its chapters on query tuning to be poor, failing to even mention transaction isolation levels and different locking.
This is not a book for beginners, but for experienced Oracle DBAs who wants to get a better handle on improving Oracle performance.
The downside of this book is that it is somewhat sloppily written and put together, almost as if the book was written as a midnight term paper The information is valuable and of high quality, just that its level or organization and writing could have used 2 From The Exclusive Publishers Of Oracle Press books Comes A Unique Volume, Packed With Undocumented Tips Techniques, For Tuning And Tailoring Oracle I To Perform At Its Peak Author Rich Niemiec Has Been Named By Oracle Corporation As One Of The Top Six Oracle Experts In The World I like two things in this book, first is an old photo of the Larry the Geek at the beginning of the book and second, a well balanced coverage of all the different tuning pieces of the mosaic known as Oracle tuning.
This book is a classic Oracle tuning book in a sense that Rich doesn t hesitate to write about ALL the important tuning pieces Yes, he even recommend proactive monitoring of instance efficiency with various hit ratios as opposed to today popular mantra of focusing solely on wait event interface reactive tuning, according to Niemiec In my opinion the correct approach is really somewhere in between the fact is that monitoring hit ratios alone actually doesn t guarantee proactive approach in all cases your instance can crawl, while at the same time hit ratios are all green , this is why I appr The book cover a wide range of issues related to performance tuning It helps me better understand the magic behind oracle PT The author is an expert in the area and used his expertise to design a PT tuning guide I would definitely recommend this book to junior and senior dbas I am looking forward to the upcoming 10g version that is set to be released sometimes next year.
I devoured this book over the weekend after a good DBA friend of mine recommend it to me Also a very senior Oracle DBA consultant who interviewed me a year ago suggested that I study it to get senior DBA job Overall an excellent text clearly written packed with tons of very useful tuning information and of course the cute photo of Mr Larry Ellison when he was 22 years old and looked like a pencil geek rather than the gazillionaire today My only beef NO CD ROM or link to ANY of the scripts or tables for the book This is frustrating guys because when I try to follow along with the tuning examples in the book I cannot duplicate same results to see how the tuning is performed Other than that gripe a highly recommend it to Oracle DBAs I also like the sections on X tables few places actually discuss this and its nic
This book is concise, practical and thorough It starts with a high level view of new 9i features and then drills down to the meat and potatoes of not just 9i tuning, but tuning skills that can be applied to any Oracle database It speaks to the beginner developer and DBA as well as the seasoned veteran tuner with equal added value for each I really enjoyed the focus of the Disk I O and Fragementation chapter It drills in the fact that no matter how hi tech or low tech your disk technology is you must adhere to the common sense basics and take ownership of your database data files, I O, partitioning and fragmentation down to the disk level and not leave it in the hands of your Hardware Admin I also like the way he incorporates GUI OEM and line command options for t Niemiec is a genius Say no.