Skip to content

Oracle Database Administration: the Essential Refe A Quick Reference for the Oracle DBA

Best in textbook rentals since 2012!

ISBN-10: 1565925165

ISBN-13: 9781565925168

Edition: 1999

Authors: David C. Kreines, Brian Laskey, Debby Russell

List price: $39.95
Blue ribbon 30 day, 100% satisfaction guarantee!
what's this?
Rush Rewards U
Members Receive:
Carrot Coin icon
XP icon
You have reached 400 XP and carrot coins. That is the daily max!

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…    
Customers also bought

Book details

List price: $39.95
Copyright year: 1999
Publisher: O'Reilly Media, Incorporated
Publication date: 5/4/1999
Binding: Paperback
Pages: 582
Size: 7.25" wide x 9.25" long x 1.25" tall
Weight: 1.980
Language: English

David Kreines is the Manager of Database Services for Rhodia, Inc., and author of Oracle SQL: The Essential Reference (O'Reilly Media, Inc., 2000) and coauthor of Oracle in a Nutshell (with Rick Greenwald) (O'Reilly Media, Inc., 2002), Oracle Database Administration: The Essential Reference (with Brian Laskey) (O'Reilly Media, Inc., 1999) and Oracle Scripts (with Brian Lomasky) (O'Reilly Media, Inc., 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, is certified as a DBA, and has been a frequent contributor to Oracle conferences, user groups, and…    

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…    

Preface
DBA Tasks
Introduction
Oracle Database Administration
Oracle Architecture
Software Options
Configuration Planning
Installation
Media Selection
The Oracle Installer
Installable Components
Dependencies
Pre-Installation Checklist
Critical Decisions
Post-Installation Tasks
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
Preventing Data Loss
Types of Backups
Database Backup
Database Recovery
Automated Utilities
Practice Scenarios
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
Security and Monitoring
Security
Monitoring
Auditing
About Auditing
Forms of the AUDIT Statement
Audit Trail Views and Lockup Tables
Establishing an Audit Policy
Maintaining the Audit Trail
Row-Level Auditing
Query Optimization
Types of Queries
Types of Join Access Paths
Determining the Access Plan
Cost-Based Optimizer
Rule-Based Optimizer
Oracle Tools
About the Tools
SQL*Plus
Oracle Server Manager
SQLDBA
Oracle Network Manager
SQL*Loader
Oracle Enterprise Manager
Third-Party Tools
DBA Reference
The Oracle Instance
Elements of the Instance
About Processes
About Memory Structures
The Oracle Database
Types of Database Files
Oracle Tablespaces
Disk Allocation
Initialization Parameters
Dynamically Modifiable Parameters
Platform-Specific Parameters
Summary of Initialization Parameters
Parameters Used Only in Oracle7
Parameters New in Oracle8
SQL Statements for the DBA
SQL Commands by Task
SQL Command Syntax
The Oracle Data Dictionary
Static Data Dictionary Views
Dynamic Performance Data Dictionary Views
System Privileges and Initial Roles
Actions, Privileges, and Roles
System Privileges
Initial Roles
Initial Users
Tools and Utilities
SQL*Plus
Export
Import
SQL*Loader
Appendix: Resources for the DBA
Index