Oracle database administration requires a vast amount of information and an ability to perform a myriad of tasks--from installation to tuning to network troubleshooting to overall daily administration. Oracle provides many tools for performing these tasks; the trick is knowing what tool is right for the job, what commands you need to issue (and when), and what parameters and privileges you need to set. And, as every DBA knows, you need to know how do all this under pressure, while you face crisis after crisis.
This book provides a concise reference to the enormous store of information an Oracle DBA needs every day (as well as what's needed only when disaster strikes). It's crammed full of quick-reference tables, task lists, and other summary material that both novice and expert DBAs will use time and time again. It covers the commands and operations new to Oracle8, but also provides Oracle7 information for sites still running earlier versions.
Oracle Database Administration provides two types of material:
DBA tasks--chapters summarizing how to perform critical DBA functions: installation, performance tuning, preventing data loss, networking, security and monitoring, auditing, query optimization, and the use of various Oracle tools and utilities
DBA reference--chapters providing a quick reference to the Oracle instance and database, the initialization (INIT.ORA) parameters, the SQL statements commonly used by DBAs, the data dictionary tables, the system privileges and roles, and the SQL*Plus, Export, Import, and SQL*Loader syntax
The book also includes a resource summary with references to additional books, Web sites, and other online and offline resources of special use to Oracle DBAs.
Oracle Database Administration is the single essential reference you'll turn to again and again. If you must choose only one book to use at the office, keep at home, or carry to a site you're troubleshooting, this will be that book.
Chapter 1 Introduction
Oracle Database Administration
Chapter 2 Installation
The Oracle Installer
Chapter 3 Maximizing Oracle Performance
Configuration and Tuning—What’s the Difference?
Achieving Maximum Performance
Configuring the Operating System
Sizing and Configuring Database Objects
Chapter 4 Preventing Data Loss
Types of Backups
Chapter 5 Oracle Networking
Oracle Network Architecture
Connecting to Non-Oracle Databases
Oracle Network Manager
Oracle Net8 Assistant
Manual Network Configuration
Sample SQL*Net Files
Chapter 6 Security and Monitoring
Chapter 7 Auditing
Forms of the AUDIT Statement
Audit Trail Views and Lookup Tables
Establishing an Audit Policy
Maintaining the Audit Trail
Chapter 8 Query Optimization
Types of Queries
Types of Join Access Paths
Determining the Access Plan
Chapter 9 Oracle Tools
About the Tools
Oracle Server Manager
Oracle Network Manager
Oracle Enterprise Manager
Chapter 10 The Oracle Instance
Elements of the Instance
About Memory Structures
Chapter 11 The Oracle Database
Types of Database Files
Chapter 12 Initialization Parameters
Dynamically Modifiable Parameters
Summary of Initialization Parameters
Parameters Used Only in Oracle7
Parameters New in Oracle8
Chapter 13 SQL Statements for the DBA
SQL Commands by Task
SQL Command Syntax
Chapter 14 The Oracle Data Dictionary
Static Data Dictionary Views
Dynamic Performance Data Dictionary Views
Chapter 15 System Privileges and Initial Roles
Actions, Privileges, and Roles
Chapter 16 Tools and Utilities
Appendix Appendix:Resources for the DBA
Oracle Database Administration: The Essential Refe
Brian Laskey is a senior database administrator for Management Information Consulting (MIC), a Virginia-based consulting firm that specializes in assisting Fortune 1000 companies in ERP systems integration and e-commerce. Brian has been an Oracle database administrator for 11 years, working with Oracle on MVS, VMS, UNIX, NT, DOS, and Windows. He is an Oracle Certified Professional, certified as a DBA for both Oracle 7.3 and Oracle 8.0. He has presented papers at the IOUW and IOUG-A Live! conferences, as well as at regional conferences. He is currently serving his second term as vice president of finance of the International Oracle Users Group-Americas, and has been a member of the board of directors of the IOUG-A for the past two years. He has just been re-elected to the IOUG-A board for a term to expire in 2001.
Our look is the result of reader comments, our own experimentation, and feedback from distribution channels. Distinctive covers complement our distinctive approach to technical topics, breathing personality and life into potentially dry subjects. The animals on the cover of Oracle Database Administration: The Essential Reference are ladybug beetles (family Coccinellidae), also known as lady beetles or ladybird beetles. Due to an attractive appearance and a diet of plant-eating aphids (some females consume up to 75 a day), these small, red or orange black-spotted beetles rank high in global opinion polls, and are even associated in some cultures with Christian symbols. In German, ladybugs are called "Marienkafer," or Mary's beetle; in French, one name for them is "les vaches de la vierge" or Cows of the Virgin. Ladybugs are effective in reducing garden pests and can be ordered from garden catalogs by the pound; they also frequently spend the winter inside people's homes, which in Canada and the U.S. is said to bring good luck. Elsewhere, the beetles are thought to signify good weather, good harvest, or other good fortune. There are thousands of ladybug species worldwide, and a few are plant eaters and pests themselves. Their colorful wing covers are more than just a pretty picture: predators generally avoid red or orange-and-black insects, as they tend to taste terrible. Other defensive maneuvers include playing dead, the production of a foul odor, and fierce-looking larvae. Madeleine Newell was the production editor and copyeditor for Oracle Database Administration: The Essential Reference. Sheryl Avruch was the production manager; Ellie Fountain Maden, Nancy Kotary, and Nicole Arigo provided quality control. Robert Romano created the illustrations using Adobe Photoshop 4 and Macromedia FreeHand 7. Mike Sierra provided FrameMaker technical support. Seth Maislin wrote the index. Maureen Dempsey, Bette Hugh, and Michael Blanding provided production assistance. Edie Freedman designed the cover of this book, using a 19th-century engraving from the Dover Pictorial Archive. The cover layout was produced by Kathleen Wilson with QuarkXPress 3.32 using the ITC Garamond font. Whenever possible, our books use RepKover, a durable and flexible lay-flat binding. If the page count exceeds RepKover's limit, perfect binding is used. The inside layout was designed by Nancy Priest and implemented in FrameMaker 5.5.6 by Mike Sierra. The text and heading fonts are ITC Garamond Light and Garamond Book. The description of ladybug beetles was written by Nancy Kotary.
Oracle Database Administration: The Essential Reference Review
By K Vainstein
Comments about O'Reilly Media Oracle Database Administration: The Essential Refe:
Marc-Oliver, don't hold your breath. O'Reilly appears intent on not updating the important books in the Oracle series, and instead publishing [a] new titles on minor/side topics, and [b] Incredibly And Yet Another PL/SQL books.
Whatever. I'm glad to have had advantage of the key books when they were still mostly relevant.