About

MICHAEL WESSLER WITH

ERIN MULDER,

ROB HARROP, AND

JAN MACHACEK

Copyright 2004 by Michael Wessler, Erin Mulder, Rob Harrop, and Jan Machacek

All rights reserved. No part of this work may be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopying, recording, or by any information storage or retrieval system, without the prior written permission of the copyright owner and the publisher.

ISBN (pbk): 1-59059-235-2

Printed and bound in the United States of America 9 8 7 6 5 4 3 2 1

Trademarked names may appear in this book. Rather than use a trademark symbol with every occurrence of a trademarked name , we use the names only in an editorial fashion and to the benefit of the trademark owner, with no intention of infringement of the trademark.

Lead Editor: Tony Davis

Technical Reviewers: Jeremy Smith and Jakob Hammer-Jakobsen

Editorial Board: Steve Anglin, Dan Appleman, Ewan Buckingham, Gary Cornell, Tony Davis, Jason Gilmore, Chris Mills, Steve Rycroft, Dominic Shakeshaft, Jim Sumser, Gavin Wray

Project Manager: Beth Christmas

Copy Edit Manager: Nicole LeClerc

Copy Editor: Mark Nigara

Production Manager: Kari Brooks

Production Editor: Kelly Winquist

Compositor: Diana Van Winkle, Van Winkle Design Group

Proofreaders: Linda Seifert, Katie Stence, Greg Teague

Indexer: Valerie Perry

Artist: Diana Van Winkle, Van Winkle Design Group

Book Designer: Diana Van Winkle, Van Winkle Design Group

Cover Designer: Kurt Krames

Manufacturing Manager: Tom Debolski

Distributed to the book trade in the United States by Springer-Verlag New York, Inc., 233 Spring Street, 6th Floor, New York, NY 10013 and outside the United States by Springer-Verlag GmbH & Co. KG, Tiergartenstr. 17, 69112 Heidelberg, Germany.

In the United States: phone 1-800-SPRINGER (1-800-777-4643), fax [phone], e-mail [e-mail] , or visit http://www.springer-ny.com .

Outside the United States: fax [phone], e-mail [e-mail] , or visit http://www.springer.de .

For information on translations, please contact Apress directly at 2560 Ninth Street, Suite 219, Berkeley, CA 94710. Phone [phone], fax [phone], e-mail info @apress.com , or visit http://www.apress.com .

The information in this book is distributed on an "as is" basis, without warranty. Although every precaution has been taken in the preparation of this work, neither the author(s) nor Apress shall have any liability to any person or entity with respect to any loss or damage caused or alleged to be caused directly or indirectly by the information contained in this work.

The source code for this book is available to readers at http://www.apress.com in the Downloads section.

To my grandmother Alma Johnson; for always being incredibly supportive and loving.

Michael Wessler

About the Authors

MICHAEL WESSLER received his BS in computer technology from Purdue University in West Lafayette, IN. He is an Oracle Certified Database Administrator for Oracle 8 and 8i, an Oracle Certified Web Administrator for 9iAS, and a 10g Database Technician. He has administered Oracle databases on Windows NT, and various flavors of UNIX and Linux, including clustered Oracle Parallel Server (OPS) environments. He also performs database and SQL/PLSQL tuning for applications. Michael has worked in many IT shops ranging from small dot-com Internet startups to large governmental agencies and corporations. Michael, who is currently consulting at the Department of Defense, is a technical manager for Perpetual Technologies, Inc.

In addition to Oracle DBA consulting, Michael has worked extensively as an Oracle 9iAS web application server administrator. Currently, he manages multiple web applications for the Department of Defense and consults at various government agencies and in the private sector. Michael also frequently lectures on 9iAS and teaches Oracle performance-tuning classes. Michael can be reached at [e-mail] or via his website at http://mike.wessler.name .

Michael is the author of Oracle DBA on Unix and Linux (SAMS, 2002). He has also coauthored Oracle Unleashed , Second Edition (SAMS, 1997), Unix Primer Plus , Third Edition (Waite Group Press, 2000), COBOL Unleashed (SAMS, 1998), and Unix Unleashed , Fourth edition (SAMS 2002).

Michael Wessler authored Chapters 9, 1521, and the appendixes.

ERIN MULDER has been working with Java since the earliest releases. In recent years , she has helped deliver many successful Java and J2EE applications, including real-time energy usage visualization, network management for video-on-demand servers, financial market analysis, federal government accounting, and contracts management. She uses a combination of open source and commercial tools, and specializes in making them work well together. Erin has also been a technical editor for several publications and has made presentations on a variety of topics at Java User Groups and JavaOne conferences. She is a software architect with Chariot Solutions, a Java consulting company in Philadelphia.

Erin Mulder authored Chapters 3 and 4 and contributed material to Chapters 114.

ROB HARROP is the lead software architect of UK-based development house, Cake Solutions Limited ( www.cakesolutions.net ). At Cake Solutions, Rob leads a team of six developers who work on enterprise solutions for a variety of clients including the Department of Trade and Industry, the Metropolitan Police, and NUS Services Limited. Rob and Cake Solutions specialize in both .NET and J2EE-based development, and Rob has been involved with .NET since the alpha stages.

Rob is the author of Pro Jakarta Velocity: From Professional to Expert (Apress, not yet published), and coauthor of Pro Jakarta Struts , Second Edition (Apress, 2004) and Pro Visual Studio .NET (Apress, not yet published).

In his limited spare time, Rob enjoys playing with different technologies, his current favorites being Groovy and aspect-oriented programming. Rob is a committer on the open-source Spring project ( www.springframework.org ), a Java and .NET application framework built around the principle of Dependency Injection. When not sitting in front of the computer, Rob usually has his head buried in a book and prefers the fantasy parodies of Terry Pratchett's Discworld.

Rob Harrop authored Chapters 68 and 13, and contributed material to Chapters 1, 2, and 5.

JAN MACHACEK is lead programmer of UK-based software company Cake Solutions Limited, where he has helped design and implement enterprise-level applications for a variety of UK- and US-based clients. In his spare time, he enjoys exploring software architectures, nonprocedural and AI programming, and playing with computer hardware.

As a proper computer geek, Jan loves the Star Wars and The Lord of the Rings series. Jan lives in Manchester in the UK and can be reached at [e-mail] .

Jan Machacek authored Chapter 12 and contributed material to Chapters 10, 13, and 14.

About the Technical Reviewers

JER SMITH entered the high-technology world in 1993 when a friend convinced him to install Linux .99 and OS/2 2.1 over Windows 3.1 on his Packard Bell computer. In Salt Lake City, UT, he owns Anagnosis (not-not-know) Consulting, a system integration and UNIX education company. He's currently working with the Department of Veteran's Affairs building's next generation Java-based clinical information systems.

JAKOB HAMMER-JAKOBSEN (born 1965) holds an MA in economic and political science and an MA in computer science. As a student, Jakob was developing student administrative programs for the university in Oracle version 5 and 6. After finishing school Jakob joined the original European distributor of Oracle TPI International, and worked as a system programmer for five years at large-scale Danish and European Oracle installations.

For three years Jakob was a member of Oracle Premium Services in Denmark, which was part of Cary Millsap's system performance group network, as a principal senior analyst. After leaving Oracle in 2001, he joined Miracle A/S where he has been working with system architecture, optimization, and programming for the last four years. Jakob also spent a year in Sydney, Australia, where he founded Miracle Australia Pty Limited. He is a member of the OakTable network.

Acknowledgments

I would like to thank the following people who have been a wonderful help in writing this book as well as in my career.

Jim Burcham, for getting me involved in Oracle application server and 9iAS in the beginning (at least, I think I thank him for that!). His guidance and logical engineering approach frequently "saves the day" for multiple systems and helps me solve many problems.

Tige Chastain for his invaluable help in the arena of operating systems and networking. He's always the guy I call first for help when I have tough Linux and UNIX questions.

Dan Wilson for showing me how to look at problems at a deeper integrated systems level rather than just looking at problems on the surface. His ability to architect and size systems has made my life easier.

Ryan Stevens, Ron Plew, and Chris Zeis from Perpetual Technologies for providing multiple opportunities in the technical consulting world. Thanks guys!

My family, especially my parents Jon and Barb, for always being supportive of my education, career, and writing.

Jamie Miller, for her remarkable support and assistance while I was writing this.

To my good friends Erik and Kalynn (and now Luke!), John and Dana, Jeff and Lindsey, TC and Colleen, and Ben, for being understanding whenever I disappear for a few months to write.

I also would like to thank the wonderful professionals I've been able to work with at Apress: Tony Davis, Beth Christmas, Mark Nigara, and Kelly Winquist.

Michael Wessler

I would like to thank Mom, Dad, the folks at Chariot, and especially Aaron for all the support and encouragement. I would also like to thank Tony Davis, Mark Nigara, Kelly Winquist, and Beth Christmas.

Erin Mulder