Oracle8i DBA Bible [Paperback]

Jonathan Gennick (Author), Carol McCullough-Dieter (Author), Gerrit-Jan Linker (Author)

Book Description

ISBN-10: 0764546236 | ISBN-13: 978-0764546235 | Publication Date: March 30, 2000

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.

Editorial Reviews

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

About the Author

Jonathan Gennick is an independent consultant specializing in Oracle technologies. He got his start with relational database systems in 1990, first working with Ingres, and then later with Digital's Rdb software. In 1994, he made the leap to Oracle and hasn't looked back since. He spends much of his time providing database administration services, as well as server-side PL/SQL support, to clients.
When he isn't working with Oracle, Jonathan can often be found writing about it. Since 1997, he has been involved with a number of writing projects. He coauthored the first edition of the book Teach Yourself PL/SQL in 21 Days. He was the technical editor for Oracle8 Server Unleashed (SAMS, 1998) and the development editor for Teach Yourself Access 2000 in 24 Hours (SAMS, 1999). His second book, Oracle SQL*Plus, The Definitive Guide, was published in 1999. In addition to coauthoring the second edition of this book, Jonathan continues to be involved in various other writing and editing projects.

Carol McCullough-Dieter lives in Portland, Oregon, with her family. She is a consultant for the Pacific Disaster Center, a federally funded project for aiding in disaster mitigation and recovery serving Hawaii and many Pacific Island countries. She has written several online tutorials covering the Oracle DBA Certification exams for DigitalThink.com. She enjoys painting watercolor portraits and volunteering at her son's school.
Carol has authored all of the Oracle books in the ...For Dummies series, beginning with Oracle7 For Dummies five years ago. She also co-authored several other books on Oracle software for IDG Books Worldwide, including the Oracle8i DBA Bible, Oracle8Developer's Guide, and Creating Cool Web Databases

Gerrit-Jan Linker is a self-employed systems programmer analyst and is currently working for Manchester Airport in the UK. Graduating as a computational chemist in 1995, he used Fortran 77 intensively on UNIX for his computations. In his first job as a trainee at a software house in the Netherlands, he was introduced to Oracle and the developer/2000 toolset. Since then, he has fully specialized in Oracle PL/SQL programming and database interfacing. Presently, he designs and implements database systems using Oracle, VB, and C on the Windows NT platform.
As a hobby, Gerrit-Jan started to write Windows programs in Visual Basic after he graduated. Now, four years later, half a dozen commercial programs are available from his Web site. It's not surprising that his most successful program is Oracle related -- Oraxcel -- his add-on that gives full Oracle access to Microsoft Excel.

Product Details

• Paperback: 1113 pages
• Publisher: Wiley (March 30, 2000)
• Language: English
• ISBN-10: 0764546236
• ISBN-13: 978-0764546235
• Product Dimensions: 9.1 x 7.4 x 2.1 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 Best Sellers Rank: #2,421,347 in Books (See Top 100 in Books)

More About the Author

I am an Oracle DBA, computer book editor, and writer residing in Munising, Michigan, and only six

blocks from Lake Superior. If you want to know more about me, please visit http://Gennick.com.

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 - See all my reviews

This review is from: Oracle8i DBA Bible (Paperback)

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 review is from: Oracle8i DBA Bible (Paperback)

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

This review is from: Oracle8i DBA Bible (Paperback)

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.