Customer Reviews

Oracle8i and Unix Performance Tuning

5 star:		(1)
4 star:		(4)
3 star:		(2)
2 star:		(0)
1 star:		(0)

 

 

This is the only book that covers indepth tuning for Oracle databases in UNIX environments. The author cover tuning from a hardware, OS perspective as well as OLTP and DSS. This edition is better than the previous two. Topics convered include Volume Management, RAID, CPU, Memory for UNIX and all aspects of Oracle tuning. I recommend this book for experienced administrators (UNIX Admins and Oracle DBAs) because the author assumes good knowledge of Oracle architecture.

This book is an excellent overview of how the Oracle RDBMS runs on the various flavors of the Unix operating system. Knowledgeable Oracle DBA's will take away many performance tuning tips with a complete understanding of why, when, and how to implement. The first two chapters on The Unix Kernel and Paging/Swapping should be required reading for anyone administering Oracle on Unix.

I thought this book covered the topic of performance tuning Oracle on UNIX thoroughly. It includes Oracle 7, 8 and 8.1 on Solaris, Sequent and HP. It includes an entire chapter on each of OLTP and DSS. It also has chapters on installation of the OS and Oracle. It didn't really add much to my knowledge of 7.3 but I picked up several good tidbits on 8i.

The book title is 8i and Unix Performance Tuning. The year is 2005. You might think the book is not applicable these days because of the "8i". Not true.

I have been working in Oracle for several years. I have administered Oracle on Windows. I have worked on Unix and have done some Oracle administration. I know commands like ls, find, vi,... But I learnt a LOT from this book on Unix side of Oracle performance tuning. I wish I had read this book few years ago when our databases started to have big IO problems. If I had, I now realize that I would have solved the problems rather than our company paying $$$ to a high priced consultant.

The book covers the Unix side of Oracle very well, like no other book does. There are so many good books out in the market for Oracle, but not many (infact none) that I know of for Oracle/Unix combo, given that most serious Oracle installations are on Unix.

If you are new to administering Oracle on Unix, please read this book before you jump in (the Unix part - first 150 pages). You may learn new things even if you are experienced, depending on your level of knowledge. It was a tough read for me, but I did it. It gives basics of Unix kernel, memory and processor tuning, configuring and tuning I/O in Unix.

An update of the book that covers 9i/10g part of Oracle would be better. And also an update of the storage systems including modern storages like SAN, NAS etc. would be great. An explanation on basics of things like shared memory segment parameters (like SHMMAX, SHMMIN,.. Why is it that no oracle book covers them?), semaphores, and **anything** UNIX for Oracle will be great too. (how about Linux?)

I hope Ahmed reads this review :)

This book has a great deal of information on the inner workings of Oracle under Unix and it covers many aspects of the Unix operating system and how it interacts with Oracle. I found the book to be very useful, the only drawback is: it is very dry and the language could be very hard to follow for some people.

A weird book. Bit outdated, some semi helpful tips included in the text. Not a bad buy for the money. It looks cool on my desk too!

The book covers Oracle,Unix and Hardware issues in equal depth. It is very much detailed (though there are very few errors) and better than most of the Oracle Tuning books.