Oracle initialization parameters : pocket reference / David C. Kreines.

Format:

Book

Author/Creator:

Kreines, David C.

Language:

English

Subjects (All):

Relational databases.

Database management.

Oracle (Computer file).

Physical Description:

1 online resource (118 p.)

Edition:

First edition.

Other Title:

Oracle initialization parameters pocket reference

Place of Publication:

Sebastopol, California : O'Reilly, 2004.

Language Note:

English

Summary:

Oracle designed its database products to be flexible and configurable so they would operate on a variety of hardware platforms, and they succeeded--Oracle software runs on more than seventy computer platforms, from mainframes to PC networks to handheld PDAs. The secret to this flexibility lies in the software's initialization parameters, whose numerous settings can be configured for top performance in countless environments. On the downside, however, improper settings can slow a system down; even grind it to a halt. And with so many parameters--which change from version to version of O

Contents:

Contents; Oracle Initialization Parameters Pocket Reference; Introduction; Acknowledgments; Conventions; Parameter Files and Types; INIT.ORA: The Initialization File; SPFILE: The Server Parameter File; Dynamically Modifiable Parameters; Parameters by Function; Auditing; Backup and Recovery; Clustered Databases; Cursors; Database Links; Distributed Operations and Heterogeneous Services; I/O and Space Management; Java; Jobs; Licenses; Locking and Transactions; Logging and Archiving; Memory Management; Names; National Language Support; Optimization and Performance; Parallel Execution; Parameters

PL/SQLRemote Sites; Rollback/Undo/Redo Management; Security; Shared Server/Multi-Threaded Server; Standby Databases; Storage; System Operations; Tracing; Miscellaneous Parameters; Parameter Quick Reference; ACTIVE_INSTANCE_COUNT; ALWAYS_ANTI_JOIN; AQ_TM_PROCESSES; ARCHIVE_LAG_TARGET; ASM_DISKGROUPS; ASM_DISKSTRING; ASM_POWER_LIMIT; AUDIT_FILE_DEST; AUDIT_TRAIL; BACKGROUND_CORE_DUMP; BACKGROUND_DUMP_DEST; BACKUP_DISK_IO_SLAVES; BACKUP_TAPE_IO_SLAVES; BITMAP_MERGE_AREA_SIZE; BLANK_TRIMMING; BUFFER_POOL_KEEP; BUFFER_POOL_RECYCLE; CIRCUITS; CLUSTER_DATABASE; CLUSTER_DATABASE_INSTANCES

CLUSTER_INTERCONNECTSCOMMIT_POINT_STRENGTH; COMPATIBLE; COMPLEX_VIEW_MERGING; CONTROL_FILE_RECORD_KEEP_TIME; CONTROL_FILES; CORE_DUMP_DEST; CPU_COUNT; CREATE_BITMAP_AREA_SIZE; CREATE_STORED_OUTLINES; CURSOR_SHARING; CURSOR_SPACE_FOR_TIME; DB_BLOCK_BUFFERS; DB_BLOCK_CHECKING; DB_BLOCK_CHECKSUM; DB_BLOCK_LRU_LATCHES; DB_BLOCK_MAX_DIRTY_TARGET; DB_BLOCK_SIZE; DB_CACHE_ADVICE; DB_CACHE_SIZE; DB_CREATE_FILE_DEST; DB_CREATE_ONLINE_LOG_DEST_n; DB_DOMAIN; DB_FILE_DIRECT_IO_COUNT; DB_FILE_MULTIBLOCK_READ_COUNT; DB_FILE_NAME_CONVERT; DB_FILES; DB_FLASHBACK_RETENTION_TARGET; DB_KEEP_CACHE_SIZE

DBLINK_ENCRYPT_LOGINDB_NAME; DB_nK_CACHE_SIZE; DB_RECOVERY_FILE_DEST; DB_RECOVERY_FILE_DEST_SIZE; DB_RECYCLE_CACHE_SIZE; DB_UNIQUE_NAME; DDL_WAIT_FOR_LOCKS; DBWR_IO_SLAVES; DB_WRITER_PROCESSES; DISK_ASYNCH_IO; DISPATCHERS; DISTRIBUTED_TRANSACTIONS; DML_LOCKS; DRS_START; ENQUEUE_RESOURCES; ENT_DOMAIN_NAME; EVENT; FAL_CLIENT; FAL_SERVER; FAST_START_IO_TARGET; FAST_START_MTTR_TARGET; FAST_START_PARALLEL_ROLLBACK; FILEIO_NETWORK_ADAPTERS; FIXED_DATE; GC_DEFER_TIME; GC_FILES_TO_LOCKS; GC_LCK_PROCS; GC_RELEASABLE_LOCKS; GC_ROLLBACK_LOCKS; GCS_SERVER_PROCESSES; GLOBAL_NAMES; HASH_AREA_SIZE

HASH_JOIN_ENABLEDHASH_MULTIBLOCK_IO_COUNT; HI_SHARED_MEMORY_ADDRESS; HS_AUTOREGISTER; IFILE; INSTANCE_GROUPS; INSTANCE_NAME; INSTANCE_NUMBER; INSTANCE_TYPE; JAVA_MAX_SESSIONSPACE_SIZE; JAVA_POOL_SIZE; JAVA_SOFT_SESSIONSPACE_LIMIT; JOB_QUEUE_INTERVAL; JOB_QUEUE_PROCESSES; LARGE_POOL_SIZE; LDAP_DIRECTORY_ACCESS; LICENSE_MAX_SESSIONS; LICENSE_MAX_USERS; LICENSE_SESSIONS_WARNING; LM_LOCKS; LM_RESS; LOCAL_LISTENER; LOCK_NAME_SPACE; LOCK_SGA; LOG_ARCHIVE_CONFIG; LOG_ARCHIVE_DEST; LOG_ARCHIVE_DEST_n; LOG_ARCHIVE_DEST_STATE_n; LOG_ARCHIVE_DUPLEX_DEST; LOG_ARCHIVE_FORMAT; LOG_ARCHIVE_LOCAL_FIRST

LOG_ARCHIVE_MAX_PROCESSES

Notes:

"Includes Oracle database 10g"--Cover.

"Oracle configuration quick reference"--Cover.

Includes index.

Description based on print version record.

ISBN:

9780596528850

059652885X

OCLC:

772458495

Publisher Number:

9780596528850