Oracle Database Administration

The Essential Reference

By: David Kreines & Brian Laskey

Write A Review

Paperback | 12 May 1999

At a Glance

Paperback
584 Pages

Dimensions(cm)
24.1 x 17.8 x 3.22

Paperback

RRP $75.95

$39.75

48%OFF

or 4 interest-free payments of $9.94 with

Ships in 15 to 25 business days

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.

Industry Reviews

'If you want a good, solid, practical reference guide covering both Oracle 7 and 8, look no further.' Dave Rutlidge, Cvu, February 2001

Shipping

	Standard Shipping	Express Shipping
Metro postcodes:	$9.99	$14.95
Regional postcodes:	$9.99	$14.95
Rural postcodes:	$9.99	$14.95

Orders over $89.00 qualify for free shipping.

How to return your order

At Booktopia, we offer hassle-free returns in accordance with our returns policy. If you wish to return an item, please get in touch with Booktopia Customer Care.

Additional postage charges may be applicable.

Defective items

If there is a problem with any of the items received for your order then the Booktopia Customer Care team is ready to assist you.

For more info please visit our Help Centre.

You Can Find This Book In

Non-Fiction Computing & I.T.Databases Database Software Oracle Data Warehousing Booktopia Publisher Services John Wiley & Sons Publishers UK

Preface	p. xi
DBA Tasks	p. 1
Introduction	p. 3
Oracle Database Administration	p. 3
Oracle Architecture	p. 6
Software Options	p. 9
Configuration Planning	p. 15
Installation	p. 20
Media Selection	p. 21
The Oracle Installer	p. 22
Installable Components	p. 23
Dependencies	p. 24
Pre-Installation Checklist	p. 24
Critical Decisions	p. 24
Post-Installation Tasks	p. 27
Maximizing Oracle Performance	p. 37
Configuration and Tuning--What's the Difference?	p. 38
Achieving Maximum Performance	p. 40
Configuring the Operating System	p. 40
Configuring Oracle	p. 41
Sizing and Configuring Database Objects	p. 46
Tuning Oracle	p. 51
Preventing Data Loss	p. 61
Types of Backups	p. 61
Database Backup	p. 64
Database Recovery	p. 69
Automated Utilities	p. 73
Practice Scenarios	p. 73
Oracle Networking	p. 77
Oracle Network Architecture	p. 77
Oracle Names	p. 83
MultiProtocol Interchange	p. 84
Connecting to Non-Oracle Databases	p. 85
Oracle Network Manager	p. 87
Oracle Net8 Assistant	p. 89
Manual Network Configuration	p. 90
Sample SQL*Net Files	p. 90
SQL*Net Troubleshooting	p. 92
Security and Monitoring	p. 97
Security	p. 97
Monitoring	p. 108
Auditing	p. 116
About Auditing	p. 116
Forms of the AUDIT Statement	p. 118
Audit Trail Views and Lockup Tables	p. 124
Establishing an Audit Policy	p. 126
Maintaining the Audit Trail	p. 127
Row-Level Auditing	p. 129
Query Optimization	p. 131
Types of Queries	p. 131
Types of Join Access Paths	p. 133
Determining the Access Plan	p. 134
Cost-Based Optimizer	p. 139
Rule-Based Optimizer	p. 157
Oracle Tools	p. 163
About the Tools	p. 163
SQL*Plus	p. 164
Oracle Server Manager	p. 168
SQLDBA	p. 169
Oracle Network Manager	p. 170
SQL*Loader	p. 171
Oracle Enterprise Manager	p. 172
Third-Party Tools	p. 175
DBA Reference	p. 177
The Oracle Instance	p. 179
Elements of the Instance	p. 179
About Processes	p. 181
About Memory Structures	p. 187
The Oracle Database	p. 193
Types of Database Files	p. 193
Oracle Tablespaces	p. 200
Disk Allocation	p. 208
Initialization Parameters	p. 212
Dynamically Modifiable Parameters	p. 213
Platform-Specific Parameters	p. 216
Summary of Initialization Parameters	p. 217
Parameters Used Only in Oracle7	p. 276
Parameters New in Oracle8	p. 277
SQL Statements for the DBA	p. 279
SQL Commands by Task	p. 279
SQL Command Syntax	p. 283
The Oracle Data Dictionary	p. 416
Static Data Dictionary Views	p. 417
Dynamic Performance Data Dictionary Views	p. 431
System Privileges and Initial Roles	p. 449
Actions, Privileges, and Roles	p. 449
System Privileges	p. 450
Initial Roles	p. 460
Initial Users	p. 465
Tools and Utilities	p. 471
SQL*Plus	p. 471
Export	p. 501
Import	p. 506
SQL*Loader	p. 512
Appendix: Resources for the DBA	p. 523
Index	p. 527
Table of Contents provided by Syndetics. All Rights Reserved.

Oracle Database Administration

The Essential Reference

At a Glance

Paperback

Industry Reviews

Shipping

How to return your order

Defective items

You Can Find This Book In

More in Databases

Statistics and Data Handling for Biologists

A Student's Guide

Statistics and Data Handling for Biologists

A Student's Guide

Python All-in-One For Dummies

3rd Edition

Navigating the AI Frontier in Business

Balancing Economy, Ecology, and Inclusion

Proceedings of the 6th International Conference on Big Data Analytics for Cyber-Physical System in Smart City, Volume 1

BDCPS 2024, December 7-8, Ji'an, China

Stochastic Control in Energy, Environmental and Resource Management Applications

Emerging Methodologies and Applications in Modelling, Identification and Control

Architecting an Apache Iceberg Lakehouse

A Scalable, Open-Source Data Platform

Microsoft Power BI For Dummies

For Dummies (Computer/Tech)

Hands-On Programming with R

Write Your Own Functions and Simulations

SPSS Survival Manual

7th Edition - A step by step guide to data analysis using IBM SPSS

Microsoft Excel 365 Bible

Bible

Code

2nd Edition - The Hidden Language of Computer Hardware and Software

The Value of People Analytics

Using HR Data to Drive Business Results

Social Research Methods

4th Edition

Microsoft 365 Access For Dummies

Access for Dummies

Coding All-in-One For Dummies

2nd Edition

Artificial Intelligence for HR

Use AI to Support and Develop a Successful Workforce

Building a Scalable Data Warehouse with Data Vault 2.0

Database Systems 6ed

A Practical Approach to Design, Implementation, and Management, Global Edition

Microsoft Power BI For Dummies

For Dummies (Computer/Tech)

Analytics Engineering with SQL and Dbt

Building Meaningful Data Models at Scale

Hands-On Machine Learning with Scikit-Learn, Keras, and Tensorflow

Concepts, Tools, and Techniques to Build Intelligent Systems

Storytelling with Data

A Data Visualization Guide for Business Professionals, 10th Anniversary Edition

Data-driven BIM for Energy Efficient Building Design

1st Edition

This product is categorised by