Oracle 8i DBA Bible - Softcover

Gennick, Jonathan; McCullough-Deiter, Carol; Linker, Gerrit-Jan

Softcover

ISBN 10: 0764546236 ISBN 13: 9780764546235

Publisher: John Wiley & Sons, 2000

Synopsis

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.

About this title

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.

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

Edition details

• Publisher: John Wiley & Sons
• Publication date: 2000
• ISBN 10: 0764546236
• ISBN 13: 9780764546235
• Binding: Paperback
• Language: English
• Number of pages: 1152