This is the only real Oracle9i database administration book in the market! This 1, 000+ page book enables a beginner or intermediate level Oracle DBA or Oracle developer/manager to master the art of building and managing complex Oracle9i databases. Expert Oracle9i Database Administration is thorough in covering all aspects of the 9i database, and includes a UNIX primer as well as an introduction to SQL and PL/SQL. Author Sam Alapati covers the entire spectrum of the new Oracle9i RDBMS software and clearly explains how to use all of its powerful features. Currently there is no one book that includes the necessary UNIX administration, Windows NT management, and SQL backgrounds and the necessary database administration principles. This book fills that gap well, by providing all the necessary material in one comprehensive volume. It takes several courses as well as mastery of several Oracle manuals to become a proficient database administrator. Readers will be able to become expert Oracle Database administrators by using this book. Expert Oracle9i Database Administration is designed to be the most complete Oracle9i database text available.Using TOAD to get the explain plan for a SQL statement The use of GUI tools helps you avoid most of the drudgery involved in producing and reading explain plans. Note that whether you use GUI tools or manual methods, the dynamic performance views that you use are the same. ... I present two of the important Tuning Pack components, the SQL Analyze and Oracle Expert applications, in the followinganbsp;...
|Title||:||Expert Oracle9i Database Administration|
|Author||:||Sam R. Alapati|
|Publisher||:||Apress - 2003-04-15|