This second edition is authored by two of the world's most widely read DBAs and Oracle internals experts, Donald Burleson and Robin Schumacher. It is an indispensable guide for any Oracle professional who is looking for real world tuning techniques. If you're a DBA who's looking for Oracle scripts and advice on how to get to the heart of critical Oracle performance problems, then you've come to the right place. Our second edition authors focus their incredible knowledge of the Oracle data dictionary into a superb book that shows how to quickly troubleshoot and correct Oracle performance problems.

If you are an Oracle DBA moving to Unix from another environment such as Windows NT or IBM Mainframe, you know that the commands you need to learn are far different from those covered in most beginning Unix books. In this handy pocket-sized book, Don Burleson introduces those Unix commands that you as an Oracle DBA most need to know.

Written by the world's most widely-read Oracle script developers and authors of over 50 best-selling Oracle books, Mike Ault, Don Burleson and Harry Conway shares their personal arsenal of Oracle data dictionary scripts in this comprehensive book. With over 50 years of combined experience using Oracle monitoring scripts and Oracle tuning scripts, this is the most comprehensive Oracle script collection ever assembled. Packed with over 100 ready-to-use Oracle scripts, this is the definitive collection for every Oracle professional DBA. It would take man-years to develop these scripts from scratch, making this book the best value in the Oracle industry. Caution - These are extremely powerful undocumented Oracle data dictionary scripts. They should only be used by a certified Oracle DBA, and after a careful review of the Oracle data dictionary script functionality. These Oracle scripts are not for beginners and knowledge of the Oracle data dictionary is required to fully utilize these scripts. USE AT YOUR OWN RISK.

Get complete coverage of STATSPACK—Oracle’s powerful tuning tool--inside this official guide. Including ready-to-use STATSPACK scripts you’ll be able to collect and analyze system data and soon have your Oracle database running at peak performance.

From the official Oracle Press comes a comprehensive guide to tuning SQL statements for optimal execution. This expert resource explains how to view the internal execution plan of any SQL statement and change it to improve the performance of the statement. Youll get details on Oracles optimizer modes, SQL extensions, the STATSPACK utility, and a wealth of methods for tuning Oracle SQL statements.

This authorized guide from Oracle Press explains how to administer Oracle9i on all of the major UNIX platforms, including Solaris, HP-UNIX and IBM-UNIX, and Linux. Inside, youll find proven techniques and UNIX scripts that can be used to perform dozens of UNIX-related tasks.