Murakami Sale
 
 

Recently Viewed clear list


Q&A | August 19, 2014

Richard Kadrey: IMG Powell’s Q&A: Richard Kadrey



Describe your latest book. The Getaway God is the sixth book in the Sandman Slim series. In it, the very unholy nephilim, James Stark, aka Sandman... Continue »
  1. $17.49 Sale Hardcover add to wish list

spacer
Qualifying orders ship free.
$5.95
Used Trade Paper
Usually ships in 5 to 7 business days
Add to Wishlist
available for shipping or prepaid pickup only
Qty Store Section
1 Remote Warehouse Database- Design

More copies of this ISBN

Oracle Database Administration: The Essential Reference

by

Oracle Database Administration: The Essential Reference Cover

 

Synopses & Reviews

Publisher Comments:

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.

Synopsis:

This quick reference guide explains everything an Oracle database administrator needs to know to plan, monitor, back up, recover, troubleshoot, and tune a database. It supplies easy-to-access syntax for parameters, SQL, Data Dictionary, privileges, utilities, error messages, and more.

Synopsis:

Part Two provides detailed reference information (command syntax, etc) needed to perform DBA functions.

Synopsis:

The Oracle database administrator (DBA) performs a vitally 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 I (Chapters 1 to 7) of this book provides essential 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 II (Chapters 8 to 17) provides detailed reference information (command syntax, etc.) needed to perform DBA functions.

This is a book for DBAs, written by DBAs — the single, definitive reference book of choice. If you must choose only one book to use at the office, to have at home, and to carry to a site you are troubleshooting, this will be that book.

A brief table of contents follows:

Part I: How to

1. Planning 2. Installation 3. Configuration and Tuning 4. Preventing Data Loss 5. Oracle Networking 6. Administration

Part II: Reference

8. Terminology and Definitions 9. The Oracle Instance 10. Initialization Parameters 11. The Database 12. SQL Statements for the DBA 13. The Oracle Data Dictionary 14. System Privileges 15. Auditing 16. The Query Optimizer 17. Tools and Utilities 18. NLS Character Sets 19. Common Errors and Their Solutions

Description:

1315607 Includes bibliographical references (p. 523-526).

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

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;

Product Details

ISBN:
9781565925168
Editor:
Russell, Deborah
Author:
Laskey, Brian
Author:
Kreines, David
Author:
Kreines, David C.
Author:
Russell, Deborah
Publisher:
O'Reilly Media
Location:
Sebastopol, CA :
Subject:
Computers
Subject:
Database Management - General
Subject:
Relational databases
Subject:
Computer software
Subject:
Sql (computer program language)
Subject:
Database Management - Oracle
Subject:
Oracle
Subject:
SQL
Subject:
Microcomputer Programming
Subject:
Computer Books: Database
Subject:
Database design
Subject:
Oracle;SQL*Loader;SQL*Plus
Edition Number:
1st ed.
Edition Description:
Print PDF
Series:
O'Reilly Oracle
Series Volume:
97-02
Publication Date:
19990431
Binding:
TRADE PAPER
Language:
English
Illustrations:
Yes
Pages:
582
Dimensions:
9.19 x 7 x 1.33 in 1.93 lb

Other books you might like

  1. Oracle PL/SQL Language Pocket Reference
    Used Trade Paper $2.48
  2. Oracle Essentials 1ST Edition Oracle... Used Trade Paper $5.95
  3. Oracle PL/SQL Built-Ins Pocket Reference
    Used Trade Paper $1.00
  4. Oracle Forms Interactive Workbook...
    New Trade Paper $40.50
  5. Oracle Scripts with CDROM Used Trade Paper $1.98
  6. Oracle Security Used Trade Paper $5.95

Related Subjects

Computers and Internet » Database » Design
Computers and Internet » Software Engineering » Software Management

Oracle Database Administration: The Essential Reference Used Trade Paper
0 stars - 0 reviews
$5.95 In Stock
Product details 582 pages O'Reilly & Associates - English 9781565925168 Reviews:
"Synopsis" by , This quick reference guide explains everything an Oracle database administrator needs to know to plan, monitor, back up, recover, troubleshoot, and tune a database. It supplies easy-to-access syntax for parameters, SQL, Data Dictionary, privileges, utilities, error messages, and more.
"Synopsis" by , Part Two provides detailed reference information (command syntax, etc) needed to perform DBA functions.
"Synopsis" by ,

The Oracle database administrator (DBA) performs a vitally 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 I (Chapters 1 to 7) of this book provides essential 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 II (Chapters 8 to 17) provides detailed reference information (command syntax, etc.) needed to perform DBA functions.

This is a book for DBAs, written by DBAs — the single, definitive reference book of choice. If you must choose only one book to use at the office, to have at home, and to carry to a site you are troubleshooting, this will be that book.

A brief table of contents follows:

Part I: How to

1. Planning 2. Installation 3. Configuration and Tuning 4. Preventing Data Loss 5. Oracle Networking 6. Administration

Part II: Reference

8. Terminology and Definitions 9. The Oracle Instance 10. Initialization Parameters 11. The Database 12. SQL Statements for the DBA 13. The Oracle Data Dictionary 14. System Privileges 15. Auditing 16. The Query Optimizer 17. Tools and Utilities 18. NLS Character Sets 19. Common Errors and Their Solutions

spacer
spacer
  • back to top
Follow us on...




Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.