Oracle8i and Unix Performance Tuning

By Ahmed Alomari

Ideal for Oracle database programmers and administrators using the UNIX platform. Shows readers how to optimize the performance of an Oracle8i database (the latest version of Oracles world-leading... This description may be from another edition of this product.

• Format: Paperback
• Language: English
• ISBN: 0130187062
• ISBN13: 9780130187062
• Release Date: September 2000
• Publisher: Prentice Hall PTR
• Length: 448 Pages
• Weight: 1.87 lbs.
• Dimensions: 9.0" x 1.3" x 7.0"

Customer Reviews

The book ROCKS!

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 :)

Real world Oracle Tuning Book...

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.

Great for Indepth Oracle tuning on UNIX

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.

Good overview for Oracle on Unix

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.

An overall guide to tuning 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.