Prentice Hall Oracle DBA Reference Library

89474-1 The complete professional's resource for building, managing, and optimizing Oracle databases! Oracle DBA Reference Library is an unparalleled practical resource for DBAs, database programmers, IT managers, and anyone who needs to make the most of Oracle database technology. It's three comprehensive, up-to-date books by world-class Oracle professionals, plus three CD-ROMs packed with tools and information, all for one great price! Oracle and UNIX Performance Tuning shows exactly how to maximize Oracle performance by systematically tuning both the database and the underlying UNIX system. It reviews important UNIX kernel performance issues, and introduces fundamental techniques for tuning memory, processors, I/O, and SQL. You'll find new, detailed recommendations for tuning both decision support and transaction applications. The CD-ROM includes shell scripts for Solaris'A (R), HP-UXaA A , and Sequent platforms, a performance monitor, Oracle scripts, a parameter reference, and extensive Oracle white papers on tuning and performance.Oracle SQL High-Performance Tuning is the first Oracle tuning guide to focus on SQL code, the #1 reason Oracle applications perform below potential. Learn general SQL tuning guidelines, techniques for choosing execution plans, working with joins, searching for nulls and ranges, building indexes, and tracing execution. Discover how to use Oracle's parallel query facility for large-volume queries, and when to use PL/SQL. Review real-world examples of poorly tuned SQL, learn how to fix it, and benchmark the results on a wide range of hardware, from UNIX SMP hosts to laptops. The CD-ROM contains a complete freeware Tuning Toolkit; plus trial versions of the SQLab tuning environment, Precise/SQL tuning suite, SQL Navigator development environment, and Personal Oracle for Windows. Oracle Database Administration for UNIX Systems is a concise Oracle administration guide for UNIX platforms, ideal for DBAs at all levels of experience. It includes step-by-step installation and configuration instructions and a detailed overview of the Oracle architecture.It covers migration, upgrades, networking, security, data integrity, backup, recovery, and security; tuning, capacity planning, GUI tools, SQL, and more. You'll find specific tips for Oracle client/server environments and insight into Oracle's next-generation DBMS, Oracle8. The CD-ROM includes the powerful database performance analysis tool DBAware.