Oracle9i DBA Handbook / Edition 1

Oracle9i DBA Handbook / Edition 1

by Kevin Loney, Marlene Theriault
     
 

ISBN-10: 0072193743

ISBN-13: 9780072193749

Pub. Date: 11/28/2001

Publisher: McGraw-Hill Professional Publishing

This authorized guide from Oracle Press explains how implement all the new features of Oracle9i and manage a robust, high-performance Oracle database. You'll get new and revised material on installation, database creation, using STATSPACK, Recovery Manager, Oracle9i Application Server, external tables, flashback queries, and much more.

Overview

This authorized guide from Oracle Press explains how implement all the new features of Oracle9i and manage a robust, high-performance Oracle database. You'll get new and revised material on installation, database creation, using STATSPACK, Recovery Manager, Oracle9i Application Server, external tables, flashback queries, and much more.

Product Details

ISBN-13:
9780072193749
Publisher:
McGraw-Hill Professional Publishing
Publication date:
11/28/2001
Series:
Oracle Press Series
Pages:
1008
Product dimensions:
7.30(w) x 9.10(h) x 1.99(d)

Table of Contents

Acknowledgmentsxxi
Introductionxxiii
Part IDatabase Architecture
1Getting Started with the Oracle Architecture3
Overview of Databases and Instances4
About Software Installation10
Creating a Database13
Background Processes33
Internal Database Structures37
2Hardware Configurations and Considerations61
Architecture Overview62
Stand-Alone Hosts63
Networked Hosts71
3Planning and Managing Tablespaces87
The End Product88
The Optimal Flexible Architecture (OFA)88
Commonsense Logical Layouts101
Solutions103
4Physical Database Layouts105
Database File Layout106
Verification of I/O Estimates118
Solutions120
File Location124
Database Space Usage Overview125
Resizing Datafiles134
How to Move Database Files135
How to Deallocate Space from Segments146
Using Oracle Managed Files (OMFs)150
Physically Fit153
Part IIDatabase Management
5Managing the Development Process157
Three Critical Elements of Success158
Cultural Processes159
Management Processes160
Technology202
Managing Package Development203
The Managed Environment207
6Monitoring Space Usage209
Common Problem Areas210
Target Selection214
The End Product214
Creating the Command Center Database218
Monitoring Memory Objects237
Additional Alerts and Warnings238
The Well-Managed Database246
7Managing Transactions247
Rollback Segments Overview248
Space Usage Within Rollback Segments254
Monitoring Rollback Segment Usage260
Using Oracle Enterprise Manager to Manage Rollback Segments267
Choosing the Number and Size272
Solutions277
Using Undo Tablespaces279
8Database Tuning283
Tuning Application Design284
Tuning SQL289
Tuning Memory Usage297
Tuning Data Storage305
Tuning Data Manipulation317
Tuning Physical Storage324
Tuning Logical Storage325
Reducing Network Traffic325
Using OEM and the Performance Tuning Packs334
Tuning Solutions341
9Using STATSPACK345
Installing STATSPACK346
10Database Security and Auditing357
Security Capabilities358
Implementing Security359
Limiting Available Commands: Product User Profiles395
Password Security During Logins397
Password Encryption and Trickery397
Virtual Private Databases403
Auditing412
Security in a Distributed Environment417
Solutions418
11Backup and Recovery Options419
Capabilities420
Logical Backups420
Physical Backups421
Implementations423
Integration of Backup Procedures469
12Using Recovery Manager (RMAN)473
About Recovery Manager474
Some RMAN Recommendations509
Part IIINetworked Oracle
13Oracle Net515
Overview of Oracle Net516
Using the Oracle Net Configuration Assistant526
Using the Oracle Net Manager535
Starting the Listener Server Process548
Controlling the Listener Server Process549
Usage Example: Client/Server Applications552
Usage Example: Database Links553
Usage Example: The copy Command554
Oracle Names Server Versus Client Configurations or Directory Servers556
Tuning Oracle Net557
UNIX and Oracle Net559
14Tuning 9iAS563
Starting, Stopping, and Restarting iAS (Apache)565
Tuning Apache and TCP567
Tuning the Oracle HTTP Server Configuration568
Using the Oracle Caching Services570
Oracle Web Cache570
Oracle9iAS Database Cache590
15Managing Large Databases593
Setting Up the Environment594
Managing Transactions616
Backups624
Tuning627
Using Transportable Tablespaces629
Locally Managed Tablespaces632
16Managing Distributed Databases635
Remote Queries637
Remote Data Manipulation: Two-Phase Commit638
Dynamic Data Replication640
Managing Distributed Data641
Managing Distributed Transactions673
Monitoring Distributed Databases675
Tuning Distributed Databases676
Using the Job Queues679
ASQL Reference for DBA Commands683
Index955

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >