Oracle8I DBA Bible (Paperback)

~ (Author), Carol McCullough-Dieter (Author), Gerrit-Jan Linker (Author) "The Internet changes everything..." (more)
Key Phrases: schema object auditing, date format elements, full tablescan, Server Manager, Enterprise Manager, Schema Manager (more...)

Editorial Reviews

Product Description

New Internet functionality and support for Linux make Oracle8i a milestone release, and this authoritative guide explains all the tools and techniques administrators need to master this potent new database. Some of the new features covered include an embedded Java Virtual Machine, expanded data warehousing capabilities, and enhanced DBA tools. You'll discover SQL* Plus basics and tools on your way to finding out more about fine-tuning performance and WebDB strategies.

The CD-ROM includes a sample Oracle 8i database, sample scripts, and SQL*Plus references.

From the Back Cover

If Oracle8I can do it, you can do it too…

Oracle8I is packed with new features, including an embedded Java Virtual Machine, expanded data warehousing capabilities, and enhanced DBA tools. This comprehensive guide shows you step-by-step how to make the most of this improved functionality — and master the day-to-day tools and challenges of Oracle database administration. From SQL*Plus basics and performance-tuning options to recovery tips and WebDB strategies, Oracle8I DBA Bible is all you need to optimize a database and keep it running smoothly.

Inside, you'll find complete coverage of Oracle8I database administration

• Install Oracle8I and configure Net8 and the password file
• Use SQL*Plus, Import, SQL*Loader, and other DBA tools, including the new wizards
• Create and manage users as well as tables, materialized views, and other database objects
• Boost performance using the rules- or cost-based optimizer, SQL statement tuning, and instance tuning
• Master advanced topics, from PL/SQL programming and the enhanced Resource Management tools to auditing and partitioning
• Harness the new Internet functionality of 8I using WebDB, the HTML server, Java, and more
• Get complete syntax references for SQL, PL/SQL built-in functions, and SQL*Plus

All this on the Companion CD-ROM

• Scripts to create and populate the sample tables in the book
• Scripts containing code examples from the book
• Oraxel Lite, which enables you to access Oracle data from Excel

Master Oracle8I administration, from data warehousing to resource management

Harness the power of PL/SQL and the Oracle8I DBA tools and utilities

Capitalize on the new Internet and e-commerce functionality

See all Editorial Reviews

Product Details

• Paperback: 1113 pages
• Publisher: Wiley (March 30, 2000)
• Language: English
• ISBN-10: 0764546236
• ISBN-13: 978-0764546235
• Product Dimensions: 9.2 x 7.4 x 2.2 inches
• Shipping Weight: 4.2 pounds (View shipping rates and policies)
• Average Customer Review: 3.2 out of 5 stars  See all reviews (8 customer reviews)
• Amazon.com Sales Rank: #1,466,391 in Books (See Bestsellers in Books)

Customer Reviews

Most Helpful Customer Reviews

6 of 7 people found the following review helpful:

4.0 out of 5 stars Great book for beginning-intermediate DBA's, April 27, 2000

By	Debra Homan (Colorado Springs) - See all my reviews

This is a very good to-the-point manual for all of the basic to intermediate subjects you need to know for Oracle 8i administration. I was surprised at how much was actually contained here relating to all of the different parts of the Oracle RDBMS world. However, it does not make a complete reference (no listing of init.ora parameters for example) and therefore garnered 4 stars from me instead of 5. It is a great book nontheless. Buy it!

1 of 1 people found the following review helpful:

2.0 out of 5 stars dissapointed, January 13, 2001

By A Customer

This book is not for beginners. Difficult to read. You really need plenty of previous Oracle knowledge to be able to understand this book. If you're a newbie, I suggest you buy another book.

4.0 out of 5 stars Useful to a new DBA, October 1, 2004

By	Bill 80127 (Littleton, CO USA) - See all my reviews

I bought this book when I started out as a DBA. It isn't the only book you'll need, but it has has excellent sections on subjects a DBA really needs to know: export, import, and sql*plus, including line editing commands. It also has more information on sql*loader than you'll find elsewhere. Those chapters alone make it worth buying.