Oracle 10g and Oracle 11g

O7_DICTIONARY_ACCESSIBILITY

FALSE

No Version 7 Dictionary Accessibility Support

active_instance_count

Number of active instances in the cluster database

aq_tm_processes

0

Number of AQ time managers to be started

archive_lag_target

0

Maximum number of seconds of redos that the standby can lose

asm_diskgroups

Disk groups to mount automatically

asm_diskstring

Disk set locations for discovery

asm_power_limit

1

Number of processes for disk rebalancing

audit_file_dest

E:\ORACLE\PRODUCT\10.2.0\ADMIN\STRESS10\ADUMP

Directory in which auditing files reside

audit_sys_operations

FALSE

No system auditing

audit_trail

NONE

No system auditing

background_core_dump

partial

Core Size for Background Processes

background_dump_dest

E:\ORACLE\PRODUCT\10.2.0\ADMIN\STRESS10\BDUMP

Detached process dump directory

backup_tape_io_slaves

FALSE

No backup tape I/O secondaries

bitmap_merge_area_size

1048576

For BITMAP MERGE, maximum amount of memory

blank_trimming

FALSE

Blank trimming semantics not allowed

buffer_pool_keep

Number of database blocks (latches) in keep the buffer pool

buffer_pool_recycle

Number of database blocks (latches) in the recycle buffer pool

circuits

Maximum number of circuits

cluster_database

FALSE

Startup not in cluster database mode

cluster_database_instances

1

Number of instances to use for sizing cluster DB SGA structures

cluster_interconnects

Interconnects for RAC use

commit_point_strength

1

Bias that this node has toward not preparing in a two-phase commit

commit_write

Write behavior of the transaction commit log

compatible

10.2.0.1.0

Database completely compatible with this software version

control_file_record_keep_time

7

Number of days that file records are kept

control_files

E:\ORACLE\PRODUCT\10.2.0\ORADATA\STRESS10\CONTROL01.CTL, E:\ORACLE\PRODUCT\10.2.0\ORADATA\STRESS10\CONTROL02.CTL, E:\ORACLE\PRODUCT\10.2.0\ORADATA\STRESS10\CONTROL03.CTL

List of control file names

core_dump_dest

E:\ORACLE\PRODUCT\10.2.0\ADMIN\STRESS10\CDUMP

Core dump directory

cpu_count

4

Number of CPUs for this instance

create_bitmap_area_size

8388608

For the bitmap index, the size of the create bitmap buffer

create_stored_outlines

For DML statements, stored outlines created

cursor_sharing

SIMILAR

Cursor sharing mode

cursor_space_for_time

FALSE

Use of more memory to obtain faster execution, not allowed

db_16k_cache_size

0

Size of cache for 16Kb buffers

db_2k_cache_size

0

Size of cache for 2Kb buffers

db_32k_cache_size

0

Size of cache for 32Kb buffers

db_4k_cache_size

0

Size of cache for 4Kb buffers

db_8k_cache_size

0

Size of cache for 8Kb buffers

db_block_buffers

0

Number of database blocks cached in memory

db_block_checking

FALSE

No header checking or data and index block checking

db_block_checksum

TRUE

Checksum stored in DB blocks and evaluated during reads

db_block_size

8192

Size of database block in bytes

db_cache_advice

ON

Buffer cache sizing advisory

db_cache_size

0

Size of DEFAULT buffer pool for standard block size buffers

db_create_file_dest

Default database location

db_create_online_log_dest_1

Online log (controlfile) destination #1

db_create_online_log_dest_2

Online log (controlfile) destination #2

db_create_online_log_dest_3

Online log (controlfile) destination #3

db_create_online_log_dest_4

Online log (controlfile) destination #4

db_create_online_log_dest_5

Online log (controlfile) destination #5

db_domain

Directory part of the global database name, stored with CREATE DATABASE

db_file_multiblock_read_count

8

Number of DB blocks to be read each IO

db_file_name_convert

Data file name convert patterns and strings for the standby (clone) DB

db_files

200

Maximum allowable number of DB files

db_flashback_retention_target

1440

Maximum Flashback Database log retention time (in minutes)

db_keep_cache_size

0

Size of KEEP buffer pool for standard block size buffers

db_name

Stress10

Database name specified in CREATE DATABASE

db_recovery_file_dest

E:\oracle\product\10.2.0/flash_recovery_area

Default database recovery file location

db_recovery_file_dest_size

2147483648

Database recovery file size limit

db_recycle_cache_size

0

Size of RECYCLE buffer pool for standard block size buffers

db_unique_name

Stress10

Database unique name

db_writer_processes

2

Number of background database writer processes to start

dbwr_io_slaves

0

DBWR I/O secondaries

ddl_wait_for_locks

FALSE

NOWAIT DML lock acquisitions disabled

dg_broker_config_file1

E:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\DR1STRESS10.DAT

Data guard broker configuration file #1

dg_broker_config_file2

E:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\DR2STRESS10.DAT

Data guard broker configuration file #2

dg_broker_start

FALSE

Data Guard broker framework (DMON process) not to be started

disk_asynch_io

TRUE

Asynch I/O used for random access devices

dispatchers

(PROTOCOL=TCP) SERVICE=Stress10XDB)

Specifications of dispatchers

distributed_lock_timeout

60

Number of seconds that a distributed transaction waits for a lock

dml_locks

748

DML locks—one for each table modified in a transaction

drs_start

FALSE

DG Broker monitor (DMON process) not to be started

event

Debug event control—default null string

fal_client

FAL client

fal_server

FAL server list

fast_start_io_target

0

Upper bound on recovery reads

fast_start_mttr_target

0

MTTR target of forward crash recovery (in seconds)

fast_start_parallel_rollback

LOW

Maximum number of parallel recovery secondaries that can be used

file_mapping

FALSE

No file mapping

fileio_network_adapters

Network adapters for file I/O

filesystemio_options

IO operations on file system files

fixed_date

Fixed SYSDATE value

gc_files_to_locks

Mapping between file numbers and global cache locks

gcs_server_processes

0

Number of background GCS server processes to start

global_context_pool_size

Global Application Context Pool size (in bytes)

global_names

FALSE

Database links and the remote database not required to have same name

hash_area_size

131072

Size of in-memory hash work area

hi_shared_memory_address

0

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

hs_autoregister

TRUE

Automatic server DD updates in HS agent self-registration enabled

ifile

File included in init.ora

instance_groups

List of instance group names

instance_name

stress10

Instance name supported by the instance

instance_number

0

Instance number

instance_type

RDBMS

Type of instance to be executed

java_max_sessionspace_size

0

Maximum allowed size in bytes of a Java sessionspace

java_pool_size

0

Size (in bytes) of Java pool

java_soft_sessionspace_limit

0

Warning limit on size (in bytes) of a Java sessionspace

job_queue_processes

10

Number of job queue secondary processes

large_pool_size

0

Size in bytes of large pool

ldap_directory_access

NONE

No RDBMS LDAP access

license_max_sessions

0

Maximum number of non-system user sessions allowed

license_max_users

0

Maximum number of named users that can be created in the database

license_sessions_warning

0

Warning level for number of non-system user sessions

local_listener

Local listener

lock_name_space

Lock name space used for generating lock names for standby (clone)

lock_sga

FALSE

SGA not locked in physical memory

log_archive_config

Log archive configuration parameter

log_archive_dest

Archival destination text string

log_archive_dest_1

Archival destination #1 text string

log_archive_dest_10

Archival destination #10 text string

log_archive_dest_2

Archival destination #2 text string

log_archive_dest_3

Archival destination #3 text string

log_archive_dest_4

Archival destination #4 text string

log_archive_dest_5

Archival destination #5 text string

log_archive_dest_6

Archival destination #6 text string

log_archive_dest_7

Archival destination #7 text string

log_archive_dest_8

Archival destination #8 text string

log_archive_dest_9

Archival destination #9 text string

log_archive_dest_state_1

enable

Archival destination #1 state text string

log_archive_dest_state_10

enable

Archival destination #10 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_dest_state_6

enable

Archival destination #6 state text string

log_archive_dest_state_7

enable

Archival destination #7 state text string

log_archive_dest_state_8

enable

Archival destination #8 state text string

log_archive_dest_state_9

enable

Archival destination #9 state text string

log_archive_duplex_dest

Duplex archival destination text string

log_archive_format

ARC%S_%R.%T

Archival destination format

log_archive_local_first

TRUE

EXPEDITE attribute default value established

log_archive_max_processes

2

Maximum number of active ARCH processes

log_archive_min_succeed_dest

1

Minimum number of archive destinations that must succeed

log_archive_start

FALSE

Archival process not to start on SGA initialization

log_archive_trace

0

Archivelog operation tracing level established

log_buffer

7024640

Reset circular buffer size

log_checkpoint_interval

0

For checkpoint threshold, the number redo blocks

log_checkpoint_timeout

1800

Maximum time interval between checkpoints (in seconds)

log_checkpoints_to_alert

FALSE

Checkpoint begin and end not to be logged to the alert file

log_file_name_convert

Log file name convert patterns and strings for standby (clone) DB

logmnr_max_persistent_sessions

1

Maximum number of threads to mine

max_commit_propagation_delay

0

Maximum age of new snapshot (in .01 second intervals)

max_dispatchers

Maximum number of dispatchers

max_dump_file_size

UNLIMITED

Maximum size (in blocks) of the dump file

max_enabled_roles

150

Maximum number of roles that a user can have enabled

max_shared_servers

Maximum number of shared servers

object_cache_max_size_percent

10

For the user session object cache, percentage by which maximum size can exceed optimal size

object_cache_optimal_size

102400

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

olap_page_pool_size

0

Size of the OLAP page pool in bytes

open_cursors

300

Maximum number of cursors per session

open_links

4

Maximum number of open links per session

open_links_per_instance

4

Maximum number of open links per instance

optimizer_dynamic_sampling

2

Optimization of dynamic sampling

optimizer_features_enable

10.2.0.1

Optimization of plan compatibility parameter

optimizer_index_caching

0

Optimization of percent index caching

optimizer_index_cost_adj

100

Optimization of index cost adjustment

optimizer_mode

ALL_ROWS

Optimizer mode

optimizer_secure_view_merging

TRUE

Optimization of secure view merging and predicate pushdown (movearound)

os_authent_prefix

OPS$

Prefix for auto-logon accounts

os_roles

FALSE

Roles not received from the operating system

parallel_adaptive_multi_user

TRUE

For multiple user streams, adaptive setting of degree enabled

parallel_automatic_tuning

FALSE

For parallel execution parameters, disabled intelligent defaults

parallel_execution_message_size

2148

Message buffer size for parallel execution

parallel_instance_group

Instance group to use for all parallel operations

parallel_max_servers

80

Maximum number of parallel query servers per instance

parallel_min_percent

0

Minimum percent of threads required for parallel query

parallel_min_servers

0

Minimum number of parallel query servers per instance

parallel_server

FALSE

Startup in parallel server mode disabled

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

pga_aggregate_target

419430400

Target size for the aggregate PGA memory consumed by the instance

plsql_ccflags

PL/SQL ccflags

plsql_code_type

INTERPRETED

PL/SQL codetype

plsql_compiler_flags

INTERPRETED, NON_DEBUG

PL/SQL compiler flags

plsql_debug

FALSE

PL/SQL debug

plsql_native_library_dir

PL/SQL native library directory

plsql_native_library_subdir_count

0

For PL/SQL native library, the number of subdirectories

plsql_optimize_level

2

PL/SQL optimize level

plsql_v2_compatibility

FALSE

PL/SQL version 2.x not compatible

plsql_warnings

DISABLE:ALL

PL/SQL compiler warnings disabled

pre_page_sga

FALSE

No pre-page SGA for process

processes

150

User processes

query_rewrite_enabled

TRUE

Query rewrites disabled

query_rewrite_integrity

enforced

Requirement to perform rewrite using materialized views with preferred integrity

rdbms_server_dn

RDBMS distinguished name

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

recyclebin

off

No recycle bin processing

remote_archive_enable

true

Remote archival enabled

remote_dependencies_mode

TIMESTAMP

Remote Procedure Call dependencies mode parameter

remote_listener

Remote listener

remote_login_passwordfile

EXCLUSIVE

Password file usage parameter

remote_os_authent

FALSE

Non-secure remote clients not allowed to use auto-logon accounts

remote_os_roles

FALSE

Non-secure remote clients not allowed to use OS roles

replication_dependency_tracking

TRUE

Dependency for replication parallel propagation tracked

resource_limit

FALSE

No resource limit

resource_manager_plan

Resource manager top plan

resumable_timeout

0

Resumable timeout setting

rollback_segments

Segment list returned to previous state

serial_reuse

disable

Frame segments not reused

service_names

Stress10

Service names supported by the instance

session_cached_cursors

20

Number of cursors cached in session.

session_max_open_files

10

Maximum number of open files allowed per session

sessions

170

Number of user and system sessions

sga_max_size

1660944384

Maximum total SGA size

sga_target

1048576000

Target size of SGA

shadow_core_dump

partial

Core size for shadow processes

shared_memory_address

0

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

shared_pool_reserved_size

5452595

Size (in bytes) of the reserved area of shared pool

shared_pool_size

0

Size (in bytes) of shared pool

shared_server_sessions

Maximum number of shared server sessions

shared_servers

1

Number of shared servers to be started

skip_unusable_indexes

TRUE

Unusable indexes skipped

smtp_out_server

utl_smtp server and port configuration parameter

sort_area_retained_size

0

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

sort_area_size

65536

Size of in-memory sort work area

spfile

E:\ORACLE\PRODUCT\10.2.0\DB_1\DBS\SPFILESTRESS10.ORA

Server parameter file

sql92_security

FALSE

Select privilege for searched update and delete not required

sql_trace

FALSE

No SQL trace

sql_version

NATIVE

SQL language version parameter for compatibility issues

sqltune_category

DEFAULT

Category qualifier for applying hintsets

standby_archive_dest

%ORACLE_HOME%\RDBMS

Destination text string for the standby database archive log

standby_file_management

MANUAL

On standby, if AUTO then files created or dropped manually

star_transformation_enabled

FALSE

Star transformation not used

statistics_level

TYPICAL

Statistics level

streams_pool_size

0

Size (in bytes) of the streams pool

tape_asynch_io

TRUE

For tape devices, asynch I/O requests used

thread

0

Redo thread to mount

timed_os_statistics

0

Internal OS statistic gathering interval in seconds

timed_statistics

TRUE

Internal timing statistics maintained

trace_enabled

FALSE

No KST tracing

tracefile_identifier

Trace file custom identifier

transactions

187

Maximum. number of concurrent active transactions

transactions_per_rollback_segment

5

Number of active transactions per rollback segment

undo_management

AUTO

Instance run in SMU mode

undo_retention

900

Undo retention (in seconds)

undo_tablespace

UNDOTBS1

Undo tablespace used

use_indirect_data_buffers

FALSE

No indirect data buffers (very large SGA on 32-bit platforms)

user_dump_dest

E:\ORACLE\PRODUCT\10.2.0\ADMIN\STRESS10\UDUMP

User process dump directory

utl_file_dir

utl_file accessible directories list

workarea_size_policy

AUTO

SQL working areas sized automatically