Oracle Initialization Parameters Pocket Reference

by Kreines, David C.

• ISBN13: 9780596007706
• ISBN10: 0596007701
• Format: Paperback
• Copyright: 2004-08-01
• Publisher: Oreilly & Associates Inc

Summary

Oracle designed its database products to be flexible and configurable so they would operate on a variety of hardware platforms. They achieved that through the software's initialization parameters, and how these parameters are set greatly affects database performance. Improper settings will cause the system to slow down, or even grind it to a halt. When DBAs and developers need to adjust these settings, the Oracle Initialization Parameters Pocket Reference provides the information at a moment's notice. This handy, easy-to-use guide describes each initialization parameter, indicates what category it's in-from auditing to multi threaded server MTS-and whether it can be modified dynamically. Users will also find performance tips-an absolute must for anyone working with an Oracle database.

Author Biography

David Kreines is the Manager of Database Services for Rhodia, Inc., and author of Oracle SQL: The Essential Reference (O'Reilly Media, Inc., 2000) and coauthor of Oracle in a Nutshell (with Rick Greenwald) (O'Reilly Media, Inc., 2002), Oracle Database Administration: The Essential Reference (with Brian Laskey) (O'Reilly Media, Inc., 1999) and Oracle Scripts (with Brian Lomasky) (O'Reilly Media, Inc., 1998). Dave has worked with Oracle as a developer and database administrator since 1985, on a wide variety of platforms, from PCs to mainframes. He is an Oracle Certified Professional, is certified as a DBA, and has been a frequent contributor to Oracle conferences, user groups, and publications, both in the United States and in Europe. Dave served two terms as president of the International Oracle Users Group -Americas (IOUG-A), and spent ten years on the board of directors.

Table of Contents

Introduction	p. 1
Acknowledgments	p. 3
Conventions	p. 4
Parameter Files and Types	p. 4
INIT.ORA: The Initialization File	p. 5
SPFILE: The Server Parameter File	p. 5
Dynamically Modifiable Parameters	p. 7
Parameters by Function	p. 8
Auditing	p. 9
Backup and Recovery	p. 9
Clustered Databases	p. 9
Cursors	p. 10
Database Links	p. 10
Distributed Operations and Heterogeneous Services	p. 10
I/O and Space Management	p. 11
Java	p. 11
Jobs	p. 11
Licenses	p. 11
Locking and Transactions	p. 12
Logging and Archiving	p. 12
Memory Management	p. 12
Names	p. 13
National Language Support	p. 14
Optimization and Performance	p. 14
Parallel Execution	p. 15
Parameters	p. 15
PL/SQL	p. 15
Remote Sites	p. 16
Rollback/Undo/Redo Management	p. 16
Security	p. 16
Shared Server/Multi-Threaded Server	p. 17
Standby Databases	p. 17
Storage	p. 17
System Operations	p. 18
Tracing	p. 18
Miscellaneous Parameters	p. 18
Parameter Quick Reference	p. 19
Index	p. 105
Table of Contents provided by Ingram. All Rights Reserved.