Oracle AppsDBAs World: InitSID.ora settings for release12

Oracle E-Business Suite Release 12
###################################
# Common Database Initialization Parameters
#

db_name = prodr12
control_files = ('/disk1/prodr12_DB/cntrlprodr12_1.dbf',
'/disk2/prodr12_DB/cntrlprodr12_2.dbf',
'/disk3/prodr12_DB/cntrlprodr12_3.dbf')

#########
#
# Database block size parameter
#
# The required block size for Oracle Applications is 8K.
# No other value may be used.
#########

db_block_size = 8192 #MP #########

#########
#
# Compatibility parameter
#
# See the release-specific section of this document for details
# of setting compatibility.
#
#########

#########
#
# _system_trig_enabled
#
# The _system_trig_enabled parameter must be set to TRUE.
# If the _system_trig_enabled parameter is set to FALSE it will
# prevent system triggers from being executed.
#
#########

_system_trig_enabled = true #MP

#########
#
# o7_dictionary_accessibility parameter
#
# This parameter must be set to FALSE for Applications Release 12.
#
########

o7_dictionary_accessibility = FALSE #MP

#########
#
# NLS parameters
#
# Some NLS parameter values are marked as being mandatory settings.
# These are the only supported settings for these parameters for
# Applications Release 12. They must not be changed to other values.
# Other NLS parameters have been given default values, which can
# be changed as required.
#
#########

nls_territory = america
nls_date_format = DD-MON-RR #MP
nls_numeric_characters = ".,"
nls_sort = binary #MP
nls_comp = binary #MP

#########
#
# Multi-Threaded Server (MTS) parameters
#
# Most Oracle Applications customers DO NOT need to use MTS,
# and the default configuration disables MTS.
#
# If MTS is used, it can have a dramatic effect on the SGA, as
# session memory, including sort and cursor areas, resides in
# the
# SGA.
#
#########

#########
#
# Auditing parameter
#
# There is a performance overhead for enabling the audit_trail
# parameter. In addition, the database administrator will need
# to implement a purge policy for the SYS.AUD$ table.
#
# Statement-level auditing should not be used.
#audit_trail = true # Uncomment if you want to enable audit_trail.
user_dump_dest = /ebiz/prodr12/udump
background_dump_dest = /ebiz/prodr12/bdump
core_dump_dest = /ebiz/prodr12/cdump
max_dump_file_size = 20480 # Limit default trace file size
to 10 MB.

########
#
# Trace file accessibility parameter
#
# As the database machine should be in a secure environment,
# setting this parameter to TRUE is recommended in order to
# facilitate trace file analysis.
#
########

_trace_files_public = TRUE

#########
#
# Processes and sessions parameters
#
# A database process can be associated with one or more database
# sessions. For all technology stack components other than Oracle
# Forms, there is a one-to-one mapping between sessions and
# processes.
# For Forms processes, there will be one database session per
# open form, with a minimum of two sessions per Forms user (one
# for the navigator form, and one for the active form).
#
# The sessions parameter should be set to twice the value of the
# processes parameter.
#
#########

processes = 200 # Max. no. of users
sessions = 400 # 2 x no. of processes
db_files = 512 # Max. no. of database files
dml_locks = 10000 # Database locks

########
#
# Cursor-related parameters
#
########

cursor_sharing = EXACT #MP
open_cursors = 600
session_cached_cursors = 500

########
#
# Buffer cache parameters
#
# The buffer cache size can have a significant effect
# on performance. Values less than 400M are unrealistic for
# most customers, and can be increased as memory permits.
#
# The use of multiple buffer pools for Oracle Applications is
# not supported. Only a single buffer pool should be used
#(i.e. the
# default).
#
########

db_cache_size = 400M
db_block_checking = FALSE
db_block_checksum = TRUE

########
#
# Log Writer parameters
#
# The log writer parameters control the size of the log buffer
# within the SGA, and how frequently the redo logs are
# checkpointed (when all dirty buffers written to disk and a new
# recovery point is created).
#
# A size of 10MB for the log buffer is a reasonable value for
# Oracle Applications. This represents a balance between
# concurrent programs and online users. The value of log_buffer
# must be a multiple of redo block size (normally 512 bytes).
#
# The checkpoint interval and timeout control the frequency of
# checkpoints.
#
########

log_checkpoint_timeout = 1200 # Checkpoint at least every 20 mins.
log_checkpoint_interval = 100000
log_buffer = 10485760
log_checkpoints_to_alert = TRUE

#########
#
# Shared pool parameters
#
# The shared pool should be tuned to minimize contention
# for SQL and PL/SQL objects. For Release 12, a reasonable st
# starting point is a size of 600M and a 60M reserved area (10%).
#
########

shared_pool_size = 600M
shared_pool_reserved_size = 60M
_shared_pool_reserved_min_alloc = 4100

# cursor_space_for_time = FALSE # Disabled by default.
########
#
# Java Pool parameter
#
# Release 12 uses Java Stored Procedures, hence an initial setting of
# 50M is used. The java pool size may need to be increased as
required.
#
########

java_pool_size = 50M

########
#
# PL/SQL parameter
#
# The utl_file_dir must be set as:
# utl_file_dir = , ...
#

########
utl_file_dir = /ebiz/prodr12/utl_file_dir

########
#
# Advanced Queuing (AQ) and Job Queue parameters
#
# AQ requires the TM process to handle delayed messages. A number
# of Application modules use AQ, including Workflow. Job Queues
# enable advanced queue to submit background jobs.
#
########

aq_tm_processes = 1
job_queue_processes = 2

########
#
# Archiving parameter
#
# Archiving parameters, including destination (optionally,
# multiple destinations in 10g R2) may be specified.
#
########

# log_archive_start = true #Uncomment if you want automatic archiving.

########
#
# Parallel execution parameters
#
# Parallel execution is used by some Oracle Applications
# concurrent programs, including DBI programs and Gathering
# Statistics. AD will also use parallel
# execution when creating large indexes.
#
########

paallel_max_servers = 8 # Max. value should be 2 x no.
of CPUs.
parallel_min_servers = 0

########
#
# Events parameters
#
# Events should only be set when explicitly requested by Oracle
# Support or Development.
# Refer to the database release-specific section for events that
# may be set.
#
########

#########
#
# Optimizer parameters
#
# The following optimizer parameters must be set as below, and may
# not be changed. No other values are supported.
#
# Refer also to the release-specific section for any additional
# optimizer parameters which must be set.
#
#########

_sort_elimination_cost_ratio =5 #MP
_like_with_bind_as_equality = TRUE #MP
_fast_full_scan_enabled = FALSE #MP
_b_tree_bitmap_plans = FALSE #MP
optimizer_secure_view_merging = FALSE #MP

#########
#
# Oracle Real Application Clusters (Oracle RAC) parameters
#
# The following Oracle RAC related parameters should be set when running
# E-Business Suite in an Oracle RAC environment.
#
#########

max_commit_propagation_delay = 0 #MP
cluster_database = TRUE #MP

#########
#
# Parallel Execution and Oracle RAC parameters
#
# It is recommended to set the parameters instance_groups and
# parallel_instance_group on each instance, to ensure that parallel
# requests do not span instances.
# For example, on instance1, set instance_groups=apps1 and
# parallel_instance_group=apps1. On instance2, set
# instance_groups=apps2 and parallel_instance_group=apps2, and so on.
#
#########

#########
#
Private memory areas parameters
#
# The automatic memory manager is used to manage the PGA memory.
# This avoids the need to manually tune the settings of
# sort_area_size and
# hash_area_size.
# The automatic memory manager also improves performance and
# scalability,
# as memory is released back to the operating system.
#
#########

pga_aggregate_target = 1G
workarea_size_policy = AUTO #MP
olap_page_pool_size = 4194304

##############################################################
#
# End of Common Database Initialization Parameters Section
#
##############################################################

##############################################################
#
# Oracle E-Business Suite Release 12
# Release-Specific Database Initialization Parameters
#
##############################################################

#########
#
# Compatibility parameter
#
# Compatibility should be set to the current release.
#
##########

compatible = 10.2.0 #MP

########
#
# Cache size parameter
#
# For 10g, the automatic SGA tuning option is required. This
# avoids the need for individual tuning of the different SGA
# caches, including the
# buffer cache, shared pool, and large pool. The automatic SGA
# tuning option improves overall performance and improves
#manageability.
########

sga_target = 2G

#Additional parameters
###########################
#
# System-managed undo parameters
#
# Oracle E-Business Suite Release 12 requires the use of system
# managed undo. This is much more efficient than rollback
# segments, and reduces the chances of snapshot too old errors. In
# addition, it is much easier to manage and administer system
# managed undo than manually managing rollback segments.
########

undo_management = AUTO #MP
undo_tablespace = APPS_UNDOTS1 #MP

#########
# PL/SQL parameters
#
# The following parameters are used to enable the PL/SQL global
# optimizer as well as native compilation.
#
#########

plsql_optimize_level = 2 #MP
plsql_code_type = native #MP
plsql_native_library_dir = ebiz/prodr12/plsql_nativelib
plsql_native_library_subdir_count = 149

#########
# Other parameters
#
# _kks_use_mutex_pin
#
# 10gR2 facilitates the use of mutexes to lock resources in a
# lightweight fashion with higher granularity.
# Note that this parameter must be set to FALSE if using 10gR2
# on HP-UX.
#########

_kks_use_mutex_pin=TRUE

####################################################################
#
# End of Release-Specific Database Initialization Parameters Section
#
####################################################################

posted by Senthil Kumaran @ 2:57 AM

0 Comments: