Cover image for Oracle9i DBA 101
Oracle9i DBA 101
Theriault, Marlene.
Personal Author:
Publication Information:
Berkeley, Calif. : McGraw-Hill/Osborne, [2002]

Physical Description:
xxii, 550 pages : illustrations ; 24 cm
General Note:
"Covers Oracle database releases 7.x, 8i, and 9i"--P. 4 of cover.


Includes index.
Title Subject:
Format :


Call Number
Material Type
Home Location
Item Holds
QA76.9.D3 T442 2002 Adult Non-Fiction Central Closed Stacks

On Order



Intended for those new to Oracle technology, this introductory guide explains the day-to-day duties of a database administrator (DBA), as well as database installation, monitoring, and managing techniques. It covers the features of Oracle9i.

Table of Contents

Acknowledgmentsp. xv
Getting Startedp. xxi
Part I Defining Your World
1 About Being an Oracle DBAp. 3
How You "Talk" to a Databasep. 4
What Is an Oracle DBA, and What Does One Do?p. 5
Types of DBAsp. 14
Things You Need to Know About SQL*Plusp. 20
2 Oracle Database Layoutp. 37
Logical vs. Physical Objectsp. 38
Oracle's "Physical" Compositionp. 43
Logical Database Objectsp. 52
3 How to Look at the Databasep. 75
The Data Dictionary Viewsp. 76
The DBA_Viewsp. 77
4 How to Look at the Database Using the V$ Viewsp. 121
General V$ View Informationp. 123
The Static, Instance-Level V$ Viewsp. 126
5 How to Protect the Databasep. 147
Views That Secure the Databasep. 148
6 How to Tune the Databasep. 177
Instance-Level Dynamic V$ Views Used for Tuningp. 179
Part II Managing Your World
7 Oracle Installation, Configuration, and Buildp. 221
About Software Installationp. 222
Software Installation Stepsp. 226
Creating a Databasep. 232
On the Number of Tablespaces and Their Layoutp. 247
Init.ora vs. SPFILE.orap. 258
Instance vs. Databasep. 260
Composition of the SGAp. 262
About the Demo Tablesp. 265
8 General Database Considerationsp. 267
The Care and Feeding of Tablespacesp. 268
Documenting Your Databasep. 289
Creating Objects in a Databasep. 291
9 What We Do Dailyp. 301
General Monitoringp. 302
User Session Statusp. 333
Monitoring Object Modificationsp. 333
Part III Protecting Your World
10 Oracle Security and Youp. 337
Internal Database Securityp. 339
Application Securityp. 354
About Auditingp. 367
External Database Securityp. 374
11 Availabilityp. 377
Availability Conceptsp. 378
Just What Are We Protecting Against?p. 380
Types of Recoveryp. 382
Types of Backupsp. 383
Database Featuresp. 393
Data Guard/Standby Databasep. 400
Real Application Clusters (RAC)p. 404
Real Application Clusters Guardp. 406
Other Availability Featuresp. 406
Part IV Tuning Your World
12 Server Performancep. 411
Understanding Performance Managementp. 413
Understanding the Critical Business Transactionsp. 417
Diagnosing a Problemp. 425
Tuning to Change Overall Response Timep. 434
Common Causes of Performance Problemsp. 451
13 Oracle-Supplied Toolsp. 459
Tuning SQL with Explain Plan, TKPROF, and Autotracep. 460
Using the Oracle Enterprise Manager (OEM)p. 474
Using Stored Outlinesp. 491
Part V Appendixes
A Glossaryp. 497
B Resourcesp. 515
On Becoming a DBAp. 516
About the Oracle Certified Professional Programp. 519
MetaLinkp. 530
Technetp. 530
A Few Useful Linksp. 531
Indexp. 533