Call now: 252-767-6166  
Oracle Training Oracle Support Development Oracle Apps

 
 Home
 E-mail Us
 Oracle Articles
New Oracle Articles


 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog


 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Analysis
 Design
 Implementation
 Oracle Support


 SQL Tuning
 Security

 Oracle UNIX
 Oracle Linux
 Monitoring
 Remote s
upport
 Remote plans
 Remote
services
 Application Server

 Applications
 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S
upport  
 Development  

 Implementation


 Consulting Staff
 Consulting Prices
 Help Wanted!

 


 Oracle Posters
 Oracle Books

 Oracle Scripts
 Ion
 Excel-DB  

Don Burleson Blog 


 

 

 


 

 

 

 

 

Oracle Concepts - Oracle8i INIT.ORA Parameters

Oracle Tips by Burleson Consulting

Oracle8i INIT.ORA Parameters

NAME

VALUE

DESCRIPTION

LOG_ARCHIVE_DEST

(PD)

Archival destination text string

LOG_ARCHIVE_DEST_1

NULL

Archival destination #1 text string

LOG_ARCHIVE_DEST_2

NULL

Archival destination #2 text string

LOG_ARCHIVE_DEST_3

NULL

Archival destination #3 text string

LOG_ARCHIVE_DEST_4

NULL

Archival destination #4 text string

LOG_ARCHIVE_DEST_5

NULL

Archival destination #5 Text string

LOG_ARCHIVE_DEST_STATE_1

enable

Archival destination #1 state text string

LOG_ARCHIVE_DEST_STATE_2

enable

Archival destination #2 state text string

LOG_ARCHIVE_DEST_STATE_3

enable

Archival destination #3 state text string

LOG_ARCHIVE_DEST_STATE_4

enable

Archival destination #4 state text string

LOG_ARCHIVE_DEST_STATE_5

enable

Archival destination #5 state text string

LOG_ARCHIVE_DUPLEX_DEST

NULL

Duplex archival destination text string

LOG_ARCHIVE_FORMAT

ARC%S.%T

Archival destination Format. %s ? log sequence %t -  thread number

LOG_ARCHIVE_MAX_PROCESSES

1

Maximum number of active ARCH processes

LOG_ARCHIVE_MIN_SUCCEED_DEST

1

Minimum number of archive destinations that must succeed

LOG_ARCHIVE_START

TRUE

Start archival process on SGA initialization

LOG_BUFFER

500k or 128k*CPU

Redo circular buffer size

LOG_CHECKPOINT_INTERVAL

(PD)

# redo blocks checkpoint threshold

LOG_CHECKPOINT_TIMEOUT

0

Maximum time interval between checkpoints in seconds

LOG_CHECKPOINTS_TO_ALERT

FALSE

Log checkpoint begin/end to alert file

LOG_FILE_NAME_CONVERT

NULL

Logfile name convert pattern and string for standby/clone database

MAX_COMMIT_PROPAGATION_DELAY

700

Max age of new snapshot in .01 seconds

MAX_DUMP_FILE_SIZE

10000

Maximum size (blocks) of dump file

MAX_ENABLED_ROLES

20

Max number of roles a user can have enabled

MAX_ROLLBACK_SEGMENTS

30

Max. number of rollback segments in SGA cache

MTS_DISPATCHERS

NULL

Specifications of dispatchers

MTS_LISTENER_ADDRESS

NULL

Address(es) of network listener

MTS_MAX_DISPATCHERS

5

Max number of dispatchers

MTS_MAX_SERVERS

20

Max number of servers

MTS_MULTIPLE_LISTENERS

FALSE

Are multiple listeners enabled?

MTS_SERVERS

1

Number of servers to start up

MTS_SERVICE

(DBD)

Service supported by dispatchers

MVIEW_REWRITE_ENABLED

FALSE

Allow rewrite of queries using materialized views if enabled

NLS_CALENDAR

Gregorian

NLS calendar system name

NLS_COMP

BINARY

NLS comparison

NLS_CURRENCY

NULL

NLS local currency symbol

NLS_DATE_FORMAT

NULL

NLS Oracle date format

NLS_DATE_LANGUAGE

NULL

NLS date language name

NLS_ISO_CURRENCY

NULL

NLS ISO currency territory name

NLS_LANGUAGE

AMERICAN

NLS language name

NLS_NUMERIC_CHARACTERS

NULL

NLS numeric characters

NLS_SORT

NULL

NLS linguistic definition name

NLS_TERRITORY

AMERICA

NLS territory name

NLS_TIME_FORMAT

NULL

Time format

NLS_TIME_TZ_FORMAT

NULL

Time with timezone format

NLS_TIMESTAMP_FORMAT

NULL

Time stamp format

NLS_TIMESTAMP_TZ_FORMAT

NULL

Timestamp with timezone format

NLS_UNION_CURRENCY

NULL

Union currency symbol

OBJECT_CACHE_MAX_SIZE_PERCENT

10

Percentage of maximum size over optimal of the user session's object cache

OBJECT_CACHE_OPTIMAL_SIZE

102400

Optimal size of the user session's object cache in bytes

OPEN_CURSORS

64

Max # cursors per process

OPEN_LINKS

4

Max # open links per session

OPEN_LINKS_PER_INSTANCE

4

Max # open links per instance

OPTIMIZER_FEATURES_ENABLE

8.0.0

Optimizer plan compatibility parameter

OPTIMIZER_INDEX_CACHING

0

Optimizer percent index caching

OPTIMIZER_INDEX_COST_ADJ

100

Optimizer index cost adjustment

OPTIMIZER_MAX_PERMUTATIONS

80000

Optimizer maximum join permutations per query block

OPTIMIZER_MODE

CHOOSE

Optimizer mode

OPTIMIZER_PERCENT_PARALLEL

100

Optimizer percent parallel

OPTIMIZER_SEARCH_LIMIT

5

Optimizer search limit

ORACLE_TRACE_COLLECTION_NAME

NULL

Oracle TRACE default collection name

ORACLE_TRACE_COLLECTION_PATH

(PD)

Oracle TRACE collection path

ORACLE_TRACE_COLLECTION_SIZE

5242880

Oracle TRACE collection file max. size

ORACLE_TRACE_ENABLE

FALSE

Oracle TRACE instance wide enable/disable

ORACLE_TRACE_FACILITY_NAME

oracled

Oracle TRACE default facility name

ORACLE_TRACE_FACILITY_PATH

(PD)

Oracle TRACE facility path

OS_AUTHENT_PREFIX

OPS$

Prefix for auto-logon accounts

OS_ROLES

FALSE

Retrieve roles from the operating system

PARALLEL_ADAPTIVE_MULTI_USER

FALSE

Enable adaptive setting of degree for multiple user streams

PARALLEL_AUTOMATIC_TUNING

FALSE

Enable intelligent defaults for parallel execution parameters

PARALLEL_BROADCAST_ENABLED

FALSE

Enable broadcasting of small inputs to hash and sort merge joins

PARALLEL_EXECUTION_MESSAGE_SIZE

4096

Message buffer size for parallel execution

PARALLEL_INSTANCE_GROUP

NULL

Instance group to use for all parallel operations

PARALLEL_MAX_SERVERS

(PD)

Maximum parallel query servers per instance

PARALLEL_MIN_PERCENT

0

Minimum percent of threads required for parallel query

PARALLEL_MIN_SERVERS

0

Minimum parallel query servers per instance

PARALLEL_SERVER

FALSE

If TRUE startup in parallel server mode

PARALLEL_SERVER_INSTANCES

1

Number of instances to use for sizing OPS SGA structures

PARALLEL_THREADS_PER_CPU

2

Number of parallel execution threads per CPU

PARALLEL_TRANSACTION_RECOVERY

LOW

Max number of parallel  recovery slaves that may be used

PARTITION_VIEW_ENABLED

FALSE

Enable/disable partitioned views

PLSQL_V2_COMPATIBILITY

FALSE

PL/SQL version 2.x  compatibility flag

PRE_PAGE_SGA

FALSE

Pre-page sga for process

PROCESSES

100

User processes

READ_ONLY_OPEN_DELAYED

FALSE

If TRUE delay opening of read only files until first access

RECOVERY_PARALLELISM

0

Number of server processes  to use for parallel recovery

REMOTE_DEPENDENCIES_MODE

TIMESTAMP

Remote-procedure-call dependencies mode parameter

REMOTE_LOGIN_PASSWORDFILE

NONE

Password file usage parameter

REMOTE_OS_AUTHENT

FALSE

allow non-secure remote clients to use auto-logon accounts

REMOTE_OS_ROLES

FALSE       

Allow non-secure remote clients to use os roles

REPLICATION_DEPENDENCY_TRACKING

TRUE

Tracking dependency for Replication parallel  propagation

RESOURCE_LIMIT

FALSE

Master switch for resource limit

RESOURCE_MANAGER_PLAN

NULL

Resource mgr top plan

REWRITE_INTEGRITY

enforce

Perform rewrite using materialized views with desired integrity

ROLLBACK_SEGMENTS

(PD)

Private undo segment list

ROW_LOCKING

Always

Row-locking

SERIAL_REUSE

DISABLE

Reuse the frame segments

SERIALIZABLE

FALSE

Serializable

SERVICE_NAMES

(DBD)

Service names supported by the instance

SESSION_CACHED_CURSORS

0

Number of cursors to save in the session cursor cache

SESSION_MAX_OPEN_FILES

10

Maximum number of open bfiles allowed per session

SESSIONS

(1.1*PROC)+5

User and system sessions

SHADOW_CORE_DUMP

PARTIAL

Include SGA in core dump (FULL) don't include it (PARTIAL)

SHARED_MEMORY_ADDRESS

0

SGA starting address (low order 32-bits on 64-bit platforms)

SHARED_POOL_RESERVED_SIZE

5% shared pool

Size in bytes of reserved area of shared pool

SHARED_POOL_SIZE

<64bit 16M

Size in bytes of shared pool

SNAPSHOT_REFRESH_INTERVAL

60

Wakeup interval in seconds for job queue processes

SNAPSHOT_REFRESH_KEEP_CONNECTIONS

FALSE

Keep network connections between execution of refreshes

SNAPSHOT_REFRESH_PROCESSES

0

Number of job queue processes to start

SORT_AREA_RETAINED_SIZE

sort_area_size

Size of in-memory sort work area retained between fetch calls

SORT_AREA_SIZE

(PD)

Size of in-memory sort work area

SORT_MULTIBLOCK_READ_COUNT

2

Multi-block read count for sorts

SQL92_SECURITY

FALSE

Require select privilege for searched update/delete

SQL_TRACE

FALSE

Enable SQL trace

STANDBY_ARCHIVE_DEST

NULL

Standby database archivelog destination text string

STAR_TRANSFORMATION_ENABLED

FALSE

Enable the use of star transformation

TAPE_ASYNCH_IO

TRUE

Use asynch I/O requests for tape devices

TEXT_ENABLE

TRUE

Enable text searching

THREAD

0

Redo thread to mount (OPS)

TIMED_OS_STATISTICS

0

Internal os statistic gathering interval in seconds

TIMED_STATISTICS

FALSE

Maintain internal timing statistics

TRANSACTION_AUDITING

TRUE

Auditing transaction generated in the redo log

TRANSACTIONS

1.1*sessions

Max. number of concurrent active transactions

TRANSACTIONS_PER_ROLLBACK_SEGMENT

5

Number of active  transactions per rollback segment

USE_INDIRECT_DATA_BUFFERS

FALSE

Enable indirect data Buffers (very large SGA on 32-bit platforms)

USER_DUMP_DEST

(PD)

User process dump directory

UTL_FILE_DIR

NULL

Utl_file accessible directories list

Oracle8i initialization parameters.

The Oracle7 and Oracle8.0 initialization parameters shown below are invalid for use with Oracle8i.

NAME                          

ALLOW_PARTIAL_SN_RESULTS        

ARCH_IO_SLAVES                   

B_TREE_BITMAP_PLANS            

BACKUP_DISK_IO_SLAVES          

CACHE_SIZE_THRESHOLD            

CLEANUP_ROLLBACK_ENTRIES        

CLOSE_CACHED_OPEN_CURSORS      

COMPATIBLE_NO_RECOVERY        

DB_BLOCK_CHECKPOINT_BATCH      

DB_BLOCK_LRU_EXTENDED_STATISTICS 

DB_BLOCK_LRU_STATISTICS          

DB_FILE_SIMULTANEOUS_WRITES

DISCRETE_TRANSACTIONS_ENABLED

DISTRIBUTED_LOCK_TIMEOUT

DISTRIBUTED_RECOVERY_CONNECTION_HOLD_TIME

DISTRIBUTED_TRANSACTIONS

FAST_FULL_SCAN_ENABLED

GC_DB_LOCKS                   

GC_FREELIST_GROUPS            

GC_LATCHES

GC_LCK_PROCS

GC_ROLLBACK_SEGMENTS          

GC_SAVE_ROLLBACK_LOCKS        

GC_SEGMENTS                   

GC_TABLESPACES                

LARGE_POOL_MIN_ALLOC

LGWR_IO_SLAVES

LOCK_SGA_AREAS

LOG_ARCHIVE_BUFFER_SIZE

LOG_ARCHIVE_BUFFERS

LOG_BLOCK_CHECKSUM

LOG_SIMULTANEOUS_COPIES

LOG_SMALL_ENTRY_MAX_SIZE

MAX_TRANSACTION_BRANCHES

MTS_LISTENER_ADDRESS

MTS_MULTIPLE_LISTENERS

MTS_RATE_LOG_SIZE

MTS_RATE_SCALE

MTS_SERVICE

OGMS_HOME

OPS_ADMIN_GROUP

PARALLEL_DEFAULT_MAX_INSTANCES

PUSH_JOIN_PREDICATE

REDUCE_ALARM

SEQUENCE_CACHE_ENTRIES

SEQUENCE_CACHE_HASH_BUCKETS

SHARED_POOL_RESERVED_MIN_ALLOC

SORT_READ_FAC

SORT_SPACEMAP_SIZE

SORT_WRITE_BUFFER_SIZE

SORT_WRITE_BUFFERS

SPIN_COUNT

TEMPORARY_TABLE_LOCKS

Table 12: Invalid initialization parameters for use with Oracle8i.

 


This is an excerpt from the eBook "Oracle DBA made Simple".

For more details on Oracle database administration, see the "Easy Oracle Jumpstart" by Robert Freeman and Steve Karam.  It?s only $19.95 when you buy it directly from the publisher here.

 


 

 
��  
 
 
Oracle Training at Sea
 
 
 
 
oracle dba poster
 

 
Follow us on Twitter 
 
Oracle performance tuning software 
 
Oracle Linux poster
 
 
 

 

Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  and include the URL for the page.


                    









Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


 

Copyright © 1996 -  2016

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.