Skip to content

Oracle DBA on UNIX and Linux

ISBN-10: 0672321580

ISBN-13: 9780672321580

Edition: 2002

Authors: Michael Wessler

List price: $49.99
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!

Description:

This book provides all the information needed to install, support, tune and upgrade Oracle databases on the Unix and Linux platforms.
Customers also bought

Book details

List price: $49.99
Copyright year: 2002
Publisher: Sams
Publication date: 10/26/2001
Binding: Paperback
Pages: 600
Size: 7.25" wide x 8.75" long x 1.25" tall
Weight: 2.134
Language: English

Introduction
Who Should Read This Book?
What Makes This Book Different?
Role of the DBA
What Is a DBA?
Types of DBAs
Database Administration Principles
Database Administration Responsibilities
Roles Within the IT Organization
DBA Mindset
Summary
Architecture of the Oracle Server
Oracle Products Relating to Database Servers
Database Versus Instance
Oracle File Types
Memory Structures
Oracle Processes
Transaction Control
Miscellaneous Database Files
Summary
Planning a Database
System Architecture
Capacity Planning/Sizing
Optimal Flexible Architecture
Application and Database Considerations
Summary
Machine Setup and Installation
Pre-Installation Setup
Installing Oracle
Summary
Creating a Database
Generating Creation Scripts
Creating the Database
Post-Creation Activities
Configuring Net8 for the New Database
Customizing Your profile File
Summary
Daily Activities
Database Views
Oracle Startup/Shutdown
User Management
Space Management
Monitoring
Summary
GUI Management Products
Oracle Enterprise Manager
TOAD
Summary
DBA Utilities
Export and Import
Common Export/Import Uses
Maintenance Benefits of Export/Import
Advanced Export and Import Techniques
Using SQL *Loader
Using LogMiner
Summary
Backup and Recovery
Importance of Backups
Backup Types
Incurring Damage on the Database
Performing Backups and Recoveries
Comprehensive Planning and Testing
Summary
When Things Go Wrong
Responding to Problems
File and Space Management
Locking
"Snapshot Too Old" Rollback Errors
Summary
Oracle Server Tuning
Database Tuning Approach
Diagnostic Utilities: UTLBSTAT/UTLESTAT and STATSPACK
Tuning Memory Structures
Tuning Rollback Segments
Avoiding File Contention
Wait Events
Locally Managed Tablespaces
Tuning Tables
Indexes
Summary
Unix Operation System Architecture
Imperative Concepts
Understanding the Kernel
Startup/Shutdown Processes in Unix
Understanding the Hardware Architecture
Summary
Unix Server Monitoring
Need for Monitoring the Server
Overview of Monitoring the Server
Monitoring Memory Issues
Monitoring Disk I/O
Monitoring the CPU
Monitoring the Network
Summary
Patches and Upgrades
What Are Patches and Upgrades?
When and How to Apply Patches
When and How to Upgrade
Additional Considerations
Summary
Migrations
What Is a Migration
Reasons to Migrate Your Database
Preparation
Migration Methods
Using ODMA
Summary
Java Inside the Database Server
Understanding the Role and Future of Java Inside Oracle
Java Overview
Supporting Java with Oracle
Managing Java Inside the Database
Summary
WebDB/Oracle Portal
What Are WebDB and Oracle Portal?
WebDB/Oracle Portal Architecture
Installation
Basic WebDB Maintenance
Log into the Site
Key Differences between Oracle Portal and WebDB
Summary
Internet Application Server (iAS)
Web Environment
Understanding and Using iAS
Installation
Configuration File Location and Apache Control
Summary
9i Server New Features
Installing the 9i Server
Setting Up Security and Logging In
Creating a Server Parameter File (SPFILE)
Using Oracle-Managed Files
Using Dynamic Memory Parameters and Multiple Block Sizes
Using Undo Tablespaces
Comprehensive Sample Schemas
Miscellaneous Features and Changes
Summary
Growth of the DBA
Growth of the DBA
Motivation
Continuing Your Education
Getting Certified
Networking with Other DBAs
Learning Systems Administration and Architecture
Learning Java
Summary
Basic Unix Commands
vi Editor
Cursor-Movement Commands
Entering Text
Editing Text
Saving and Exiting
Miscellaneous Commands
Scripts
Hot Backup Script
Glossary
Index