The Oracle database administrator (DBA) performs an important set of tasks at an Oracle site: database monitoring, backup and recovery, troubleshooting, and tuning for reliability and performance. The DBA also plays a role in initial database design, system configuration, installation, and security planning. This book provides a quick reference to the myriad details an Oracle DBA needs on a day-to-day basis to help do his or her job well. Part One provides information and examples of how to perform a variety of critical DBA functions. The information in this section is presented in roughly the same sequence that these functions would be performed as the DBA plans and implements a new Oracle installation. Part Two provides detailed reference information (command syntax, etc) needed to perform DBA functions.
By:
David Kreines & Brian Laskey,
Brian Laskey
Imprint: O'Reilly Media
Country of Publication: United States
Dimensions:
Height: 233mm,
Width: 178mm,
Spine: 29mm
Weight: 916g
ISBN: 9781565925168
ISBN 10: 1565925165
Pages: 580
Publication Date: 12 May 1999
Recommended Age: From 18 to 99
Audience:
Professional and scholarly
,
Undergraduate
Format: Book
Publisher's Status: Active
Preface. I. DBA Tasks. 1. Introduction Oracle Database Administration Oracle Architecture Software Options Configuration Planning. 2. Installation Media Selection The Oracle Installer Installable Components Dependencies Pre-Installation Checklist Critical Decisions Post-Installation Tasks. 3. Maximizing Oracle Performance Configuration and Tuning-What's the Difference? Achieving Maximum Performance Configuring the Operating System Configuring Oracle Sizing and Configuring Database Objects Tuning Oracle. 4. Preventing Data Loss Types of Backups Database Backup Database Recovery Automated Utilities Practice Scenarios. 5. Oracle Networking Oracle Network Architecture Oracle Names MultiProtocol Interchange Connecting to Non-Oracle Databases Oracle Network Manager Oracle Net8 Assistant Manual Network Configuration Sample SQL*Net Files SQL*Net Troubleshooting. 6. Security and Monitoring Security Monitoring. 7. Auditing About Auditing Forms of the AUDIT Statement Audit Trail Views and Lookup Tables Establishing an Audit Policy Maintaining the Audit Trail Row-Level Auditing. 8. Query Optimization Types of Queries Types of Join Access Paths Determining the Access Plan Cost-Based Optimizer Rule-Based Optimizer. 9. Oracle Tools About the Tools SQL*Plus Oracle Server Manager SQLDBA Oracle Network Manager SQL*Loader Oracle Enterprise Manager Third-Party Tools. II. DBA Reference. 10. The Oracle Instance Elements of the Instance About Processes About Memory Structures. 11. The Oracle Database Types of Database Files Oracle Tablespaces Disk Allocation. 12. Initialization Parameters Dynamically Modifiable Parameters Platform-Specific Parameters Summary of Initialization Parameters Parameters Used Only in Oracle7 Parameters New in Oracle8. 13. SQL Statements for the DBA SQL Commands by Task SQL Command Syntax. 14. The Oracle Data Dictionary Static Data Dictionary Views Dynamic Performance Data Dictionary Views. 15. System Privileges and Initial Roles Actions, Privileges, and Roles System Privileges Initial Roles Initial Users. 16. Tools and Utilities SQL*Plus Export Import SQL*Loader. Appendix: Resources for the DBA
David C. Kreines is the manager of database services for Rhodia, Inc., a subsidiary of Rhone-Poulenc S.A., and the coauthor of Oracle Scripts (O'Reilly & Associates, 1998). Dave has worked with Oracle as a developer and database administrator since 1985, on a wide variety of platforms from PCs to mainframes. He is an Oracle Certified Professional, certified as a DBA, and has been a frequent contributor to Oracle conferences, user groups, and publications, both in the United States and in Europe. Dave served two terms as president of the International Oracle Users Group-Americas and spent ten years on the board of directors. 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.
Reviews for Oracle Database Administration: Essential Reference
'If you want a good, solid, practical reference guide covering both Oracle 7 and 8, look no further.' Dave Rutlidge, Cvu, February 2001
