Implementing and Managing Oracle Databases Book

	Introduction	xxiv
Part I	Implementing Your Oracle Database	1
Chapter 1	Overview of Oracle Databases	3
	What Is an Oracle Database?	4
	The Oracle Server	5
	From VMS to Unix and NT	12
	What's Included with Oracle?	16
	Summary	20
Chapter 2	Administrating the Lifecycle of an Oracle Database	21
	The Oracle Database Lifecycle	22
	Summary	29
Chapter 3	The Oracle Database Administrator	31
	The Skill Set of the DBA	32
	Types of Oracle DBAs	36
	Fundamental Practices of DBAs	37
	Top 99 Responsibilities of a DBA	40
	Summary	45
Chapter 4	Understanding Oracle Licenses	47
	Managing the License Process	48
	Administering Software Licenses	50
	Auditing Software Licenses	52
	Gauging Peak Demand	52
	Hoarding Licenses	53
	Leveraging and Standardization	54
	Obtaining and Managing Licenses	55
	Using Service-Level Agreements	55
	Licensing Oracle's RDBMS	56
	Summary	63
Chapter 5	What's Oracle8i All About?	65
	Understanding Oracle8i	67
	Reorganizing and Defragmenting Your Database with Oracle	73
	Internet Application Support	77
	Web Site Development	78
	Oracle Enterprise Manager 2.0	79
	Oracle Parallel Server	79
	Oracle8i's Backup and Recovery Features	80
	Oracle8i Management and Security Features	83
	Oracle Optimizer	84
	INIT.ORA Parameters	85
	Obsolete Parameters	85
	Implementing Oracle8i Successfully	86
	Summary	88
Chapter 6	Preparing for Installation	89
	Oracle's Architecture using OFA	91
	Oracle Object and Schema Naming Standards	96
	Database Parameters	102
	Normalization	103
	Key In, Ignition On! (Starting Up the Database)	105
	Ignition Off, Key Out! (Shutting Down the Database)	106
	Summary	108
Chapter 7	Installing Oracle--Step by Step!	109
	Installing Oracle RDBMS on Windows NT/2000	111
	What's Next?	129
	Installing Oracle's Enterprise Manager on Windows NT/2000	130
	Summary	136
Part II	Maintaining Your Oracle Database	139
Chapter 8	Understanding Problems, Risks, and Errors	141
	Sources of Risk	142
	Managing Risks	143
	Knowledge Discovery for Problem Solving	152
	Summary	154
Chapter 9	Choosing Manual or Automatic Database Management	155
	The Many Available Database Tools	156
	Avoiding "Analysis Paralysis" by Justifying the Purchase of Database Tools	162
	Summary	169
Chapter 10	Maintaining Your Oracle Database with 5-Nines	171
	The High-Availability Environment	173
	Achieving 5-Nines Availability	175
	Maintaining Uptime and Availability	177
	Summary	181
Chapter 11	Monitoring Your Oracle Database	183
	What to Monitor, and How Often	184
	Monitoring Technologies	186
	Dynamic Performance Tables	191
	Reporting/Trending	194
	Monitoring Security	195
	Summary	198
Chapter 12	Analyzing, Tuning, and Reporting on Oracle	199
	Generating an Analysis and Tuning Report (ATR)	200
	Summary	228
Chapter 13	Planning for Disaster Recovery	229
	Disaster Plan Issues	232
	The Makeup of the DRP	232
	Calling Oracle: The TAR Process	235
	Summary	240
Chapter 14	Replicating Oracle Databases	241
	Devising a Replication Strategy	242
	Creating Snapshots	248
	Advanced Symmetric Replication	250
	Propagating Changes between Replicas	254
	Conflict Resolution	255
	Replication Analysis and Planning	257
	Replication Initiation	260
	Replication for Recovery	261
	Managing Replicated Environments	262
	Security	267
	Summary	268
Part III	Supporting and Documenting Your Oracle Database	271
Chapter 15	Oracle Support and Publications	273
	Oracle Support Options	274
	Oracle Electronic Information Resources	277
	Oracle Published Resources	280
	Additional Oracle Numbers	283
	Summary	283
Chapter 16	WWW Dot Oracle Dot Com	285
	Web Sites	286
	Oracle FTP Sites	297
	Oracle Newsgroups	298
	Summary	299
Chapter 17	More WWW Dot Oracle Dot Com.	301
	Summary	311
Chapter 18	What Does It Take to Be an Application Service Provider?	313
	Benefits of Using an ASP	314
	ASP Categories	315
	Types of ASP Services	316
	Identifying Your Company's Requirements	318
	Selecting an ASP to Meet Your Business Requirements	319
	Pricing ASP Services	328
	Summary	330
Part IV	Appendices	333
Appendix A	DBA Templates and Checklists	335
	Sample Tool Evaluation Template	336
	Disaster Recovery Plan Template	341
	Oracle8i Enterprise Edition 8.1.6.0.0	357
	Oracle8i Enterprise Manager 2.1.0.0.0	363
	Quick Scripts	365
Appendix B	Usage, Performance, and Other Oracle Scripts	373
	Database System/Object Scripts	374
	Database Storage Scripts	377
	Database Performance Scripts	379
	Database Usage Scripts	386
	Miscellaneous Oracle Scripts	392
	Glossary	397
	Index	405