Oracle9i DBA Handbook / Edition 1

by Kevin Loney, Marlene Theriault

Overview

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.




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 LLC
Publication date:	11/28/2001
Series:	Oracle Press
Pages:	1008
Product dimensions:	7.30(w) x 9.10(h) x 1.99(d)

About the Author

Kevin Loney (Wilmington, DE) is a veteran Oracle developer and DBA. He is the author of the best-selling Oracle8 DBA Handbook and co-author of Advanced Tuning and Administration and Oracle8i: The Complete Reference. He frequently makes presentations at Oracle conferences and contributes to Oracle Magazine

Marlene Theriault has been an Oracle DBA for over 17 ears and has worked with Oracle products since version 2.0 of the Oracle RDBMS. She has been published in magazines and conference proceedings throughout the world. Ms. Theriault received the "Best User Presentation" award at EOUG 1999, "Outstanding Speaker" at EDO'98, and the "Distinguished Speaker" award for presentations at both ECO'95 and ECO'96. She coauthored Oracle Security with William Heney (O'Reilly and Associates, 1998); The Oracle8i DBA Handbook with Kevin Loney (Oracle Press, 2000); and Oracle DBA 101 with Rachel Carmichael and James Viscusi (Oracle Press, 2000). She is chair of the MAOP DBA SIG and authors an "Ask The DBA" column for the MAOP newsletter. Ms. Theriault is an avid recreational walker (Volksmarching) and has done at least one 6-mile walk in each of the 50 United States. Marlene can be reached at [e-mail].

Table of Contents

	Acknowledgments	xxi
	Introduction	xxiii
Part I	Database Architecture
1	Getting Started with the Oracle Architecture	3
	Overview of Databases and Instances	4
	About Software Installation	10
	Creating a Database	13
	Background Processes	33
	Internal Database Structures	37
2	Hardware Configurations and Considerations	61
	Architecture Overview	62
	Stand-Alone Hosts	63
	Networked Hosts	71
3	Planning and Managing Tablespaces	87
	The End Product	88
	The Optimal Flexible Architecture (OFA)	88
	Commonsense Logical Layouts	101
	Solutions	103
4	Physical Database Layouts	105
	Database File Layout	106
	Verification of I/O Estimates	118
	Solutions	120
	File Location	124
	Database Space Usage Overview	125
	Resizing Datafiles	134
	How to Move Database Files	135
	How to Deallocate Space from Segments	146
	Using Oracle Managed Files (OMFs)	150
	Physically Fit	153
Part II	Database Management
5	Managing the Development Process	157
	Three Critical Elements of Success	158
	Cultural Processes	159
	Management Processes	160
	Technology	202
	Managing Package Development	203
	The Managed Environment	207
6	Monitoring Space Usage	209
	Common Problem Areas	210
	Target Selection	214
	The End Product	214
	Creating the Command Center Database	218
	Monitoring Memory Objects	237
	Additional Alerts and Warnings	238
	The Well-Managed Database	246
7	Managing Transactions	247
	Rollback Segments Overview	248
	Space Usage Within Rollback Segments	254
	Monitoring Rollback Segment Usage	260
	Using Oracle Enterprise Manager to Manage Rollback Segments	267
	Choosing the Number and Size	272
	Solutions	277
	Using Undo Tablespaces	279
8	Database Tuning	283
	Tuning Application Design	284
	Tuning SQL	289
	Tuning Memory Usage	297
	Tuning Data Storage	305
	Tuning Data Manipulation	317
	Tuning Physical Storage	324
	Tuning Logical Storage	325
	Reducing Network Traffic	325
	Using OEM and the Performance Tuning Packs	334
	Tuning Solutions	341
9	Using STATSPACK	345
	Installing STATSPACK	346
10	Database Security and Auditing	357
	Security Capabilities	358
	Implementing Security	359
	Limiting Available Commands: Product User Profiles	395
	Password Security During Logins	397
	Password Encryption and Trickery	397
	Virtual Private Databases	403
	Auditing	412
	Security in a Distributed Environment	417
	Solutions	418
11	Backup and Recovery Options	419
	Capabilities	420
	Logical Backups	420
	Physical Backups	421
	Implementations	423
	Integration of Backup Procedures	469
12	Using Recovery Manager (RMAN)	473
	About Recovery Manager	474
	Some RMAN Recommendations	509
Part III	Networked Oracle
13	Oracle Net	515
	Overview of Oracle Net	516
	Using the Oracle Net Configuration Assistant	526
	Using the Oracle Net Manager	535
	Starting the Listener Server Process	548
	Controlling the Listener Server Process	549
	Usage Example: Client/Server Applications	552
	Usage Example: Database Links	553
	Usage Example: The copy Command	554
	Oracle Names Server Versus Client Configurations or Directory Servers	556
	Tuning Oracle Net	557
	UNIX and Oracle Net	559
14	Tuning 9iAS	563
	Starting, Stopping, and Restarting iAS (Apache)	565
	Tuning Apache and TCP	567
	Tuning the Oracle HTTP Server Configuration	568
	Using the Oracle Caching Services	570
	Oracle Web Cache	570
	Oracle9iAS Database Cache	590
15	Managing Large Databases	593
	Setting Up the Environment	594
	Managing Transactions	616
	Backups	624
	Tuning	627
	Using Transportable Tablespaces	629
	Locally Managed Tablespaces	632
16	Managing Distributed Databases	635
	Remote Queries	637
	Remote Data Manipulation: Two-Phase Commit	638
	Dynamic Data Replication	640
	Managing Distributed Data	641
	Managing Distributed Transactions	673
	Monitoring Distributed Databases	675
	Tuning Distributed Databases	676
	Using the Job Queues	679
A	SQL Reference for DBA Commands	683
	Index	955