Oracle Database Administration

Be the first to write a review

Overview

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...

See more details below
Paperback
$30.34
BN.com price
(Save 24%)$39.95 List Price
Other sellers (Paperback)
  • All (27) from $1.99   
  • New (7) from $24.99   
  • Used (20) from $1.99   
Sending request ...

More About This Book

Overview

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 SQLPlus, Export, Import, and SQLLoader 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.
Read More Show Less

Editorial Reviews

From Barnes & Noble

This book shows Oracle database administrators how to plan and perform critical functions. It is divided into two parts: The first addresses DBA tasks, such as data loss, networking, security and auditing. The second part, a reference section, includes SQL statements, an Oracle data dictionary and initialization parameters.

Highlights:

  • Explores data loss prevention options, including types of backups, database recovery and automated utilities.
  • Discusses common security holes, such as SCOTT accounts with the standard TIGER password and shared UTL_FILE access to directories.
  • Shows you how to track access to individual objects, how to use specific SQL statements and how to exercise system privileges with auditing.
  • Explains how to optimize queries by providing the cost-based optimizer with query optimization hints, which overrides normal processing.

Advantages:

  • Includes a comprehensive listing of common SQL commands sorted by task and by syntax.
  • Provides you with a complete list of the new Oracle8 system privileges.

Related Titles:

For references on administering Oracle database systems on UNIX systems, see Oracle8 and UNIX Performance Tuning. For administering Oracle on a Windows NT system, try Oracle8 Database Administration o'n Windows NT.

Read More Show Less

Product Details

  • ISBN-13: 9781565925168
  • Publisher: O'Reilly Media, Incorporated
  • Publication date: 4/21/1999
  • Edition number: 1
  • Pages: 582
  • Sales rank: 1070775
  • Product dimensions: 7.07 (w) x 9.19 (h) x 1.33 (d)

Meet the Author

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.

Read More Show Less

Table of Contents

Dedication;
Preface;
Why We Wrote This Book;
Versions of Oracle;
How This Book Is Organized;
Conventions Used in This Book;
Comments and Questions;
Acknowledgments;
DBA Tasks;
Chapter 1: Introduction;
1.1 Oracle Database Administration;
1.2 Oracle Architecture;
1.3 Software Options;
1.4 Configuration Planning;
Chapter 2: Installation;
2.1 Media Selection;
2.2 The Oracle Installer;
2.3 Installable Components;
2.4 Dependencies;
2.5 Pre-Installation Checklist;
2.6 Critical Decisions;
2.7 Post-Installation Tasks;
Chapter 3: Maximizing Oracle Performance;
3.1 Configuration and Tuning—What’s the Difference?;
3.2 Achieving Maximum Performance;
3.3 Configuring the Operating System;
3.4 Configuring Oracle;
3.5 Sizing and Configuring Database Objects;
3.6 Tuning Oracle;
Chapter 4: Preventing Data Loss;
4.1 Types of Backups;
4.2 Database Backup;
4.3 Database Recovery;
4.4 Automated Utilities;
4.5 Practice Scenarios;
Chapter 5: Oracle Networking;
5.1 Oracle Network Architecture;
5.2 Oracle Names;
5.3 MultiProtocol Interchange;
5.4 Connecting to Non-Oracle Databases;
5.5 Oracle Network Manager;
5.6 Oracle Net8 Assistant;
5.7 Manual Network Configuration;
5.8 Sample SQL*Net Files;
5.9 SQL*Net Troubleshooting;
Chapter 6: Security and Monitoring;
6.1 Security;
6.2 Monitoring;
Chapter 7: Auditing;
7.1 About Auditing;
7.2 Forms of the AUDIT Statement;
7.3 Audit Trail Views and Lookup Tables;
7.4 Establishing an Audit Policy;
7.5 Maintaining the Audit Trail;
7.6 Row-Level Auditing;
Chapter 8: Query Optimization;
8.1 Types of Queries;
8.2 Types of Join Access Paths;
8.3 Determining the Access Plan;
8.4 Cost-Based Optimizer;
8.5 Rule-Based Optimizer;
Chapter 9: Oracle Tools;
9.1 About the Tools;
9.2 SQL*Plus;
9.3 Oracle Server Manager;
9.4 SQLDBA;
9.5 Oracle Network Manager;
9.6 SQL*Loader;
9.7 Oracle Enterprise Manager;
9.8 Third-Party Tools;
DBA Reference;
Chapter 10: The Oracle Instance;
10.1 Elements of the Instance;
10.2 About Processes;
10.3 About Memory Structures;
Chapter 11: The Oracle Database;
11.1 Types of Database Files;
11.2 Oracle Tablespaces;
11.3 Disk Allocation;
Chapter 12: Initialization Parameters;
12.1 Dynamically Modifiable Parameters;
12.2 Platform-Specific Parameters;
12.3 Summary of Initialization Parameters;
12.4 Parameters Used Only in Oracle7;
12.5 Parameters New in Oracle8;
Chapter 13: SQL Statements for the DBA;
13.1 SQL Commands by Task;
13.2 SQL Command Syntax;
Chapter 14: The Oracle Data Dictionary;
14.1 Static Data Dictionary Views;
14.2 Dynamic Performance Data Dictionary Views;
Chapter 15: System Privileges and Initial Roles;
15.1 Actions, Privileges, and Roles;
15.2 System Privileges;
15.3 Initial Roles;
15.4 Initial Users;
Chapter 16: Tools and Utilities;
16.1 SQL*Plus;
16.2 Export;
16.3 Import;
16.4 SQL*Loader;
Appendix:Resources for the DBA;
Books;
Other Publications;
Organizations;
Web Sites;
Discussion Groups;
List Servers;
Colophon;

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)
Sort by: Showing 1 Customer Reviews

  • Anonymous

    Posted Wed Jan 10 00:00:00 EST 2001

    If this book had a belt clip, I'd wear it.

    Joking aside, more than any other book, this one has helped me progress from a beginning Oracle DBA to an intermediate DBA. The first half of the book imparts a general understanding of the essential tasks a DBA must master, each presented with enough information to provide valuable instruction, yet in a clear and concise text. Topics included are installation, tuning, backup and recovery (with several scenarios detailed), networking, and security. Part I is an excellent overview for beginning and intermediate DBAs. After reading Part I, I now exclusively use Part II as a reference to all those details that often must be found elsewhere by paging through several huge volumes. The reference section includes SQL*Plus, Export, Import, init parameters, v$ views, dba_ tables, SQL statements (my favorite), roles and privileges, and more. This book is well organized with an incredible index, and with binding that can take the use it will certainly get. As the title says, it is truly an essential reference.

    Was this review helpful? Yes  NoThank you for your feedback.   Report this reviewThank you, this review has been flagged.
Sort by: Showing 1 Customer Reviews
If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)