0] Query Hidden parameters
col
CURRENT_VAL for a10
select
a.ksppinm hidden_name, b.ksppstvl current_val, b.KSPPSTDF default_val from
X$KSPPI a, x$ksppsv b where a.indx = b.indx and a.ksppinm like '%max_services%'
order by 1 ;
1] 10g
Examples I
use as a start.
#########
#
# Database
Identification
#
#########
db_domain="corp.fr"
db_name=PPRQU
# Identification Data
Guard
db_unique_name=PPRQU
instance_name=PPRQU
compatible=10.2.0
# 1/ structure
#########
#
# Cache and I/O
#
#########
db_block_size=8192
#########
#
# File Configuration
#
#########
control_files=("/rdo1/pprqu/ctl/cntl_1.ctl",
"/rdo2/pprqu/ctl/cntl_2.ctl")
#########
#
# System Managed Undo
and Rollback Segments
#
#########
undo_management=AUTO
undo_tablespace=UNDO
#########
#
# Redo Log and
Recovery
#
#########
fast_start_mttr_target=300
log_checkpoint_timeout=0
#########
#
# Archive
#
#########
log_archive_dest_1='LOCATION=/arch/pprqu/'
log_archive_format='PPRQU%t_%s_%r.arc'
# 2/ logs
#########
#
# Diagnostics and
Statistics
#
#########
background_dump_dest=/work/oracle/pprqu/bdump
core_dump_dest=/work/oracle/pprqu/cdump
user_dump_dest=/work/oracle/pprqu/udump
timed_statistics=TRUE
max_dump_file_size =
20480
#########
#
# Security and
Auditing
#
#########
audit_file_dest=/work/oracle/pprqu/adump
remote_login_passwordfile=EXCLUSIVE
os_authent_prefix=''
remote_os_authent=TRUE
# 3/ SGA
#########
#
# SGA Memory
#
#########
sga_target=288M
# 4/ sessions
#########
#
# Processes and
Sessions
#
# 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.
#
#########
processes=256
sessions=512
#########
#
# Cursors and Library
Cache
#
#########
cursor_sharing = EXACT
open_cursors=300
session_cached_cursors
= 200
#########
#
# Sort, Hash Joins,
Bitmap Indexes
#
#########
pga_aggregate_target=64m
# MTS
sort_area_size=16777216
hash_area_size=16777216
#########
#
# MTS
#
#########
dispatchers='(protocol=TCP)(disp=2)'
max_dispatchers=4
shared_servers=4
max_shared_servers=8
# 5/ optimiseur
#########
#
# Optimizer
#
#########
_b_tree_bitmap_plans=false
optimizer_secure_view_merging=false
# 6/ Divers
#########
#
# Advanced Queuing
(AQ) and Job Queues
#
# 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=5
#########
#
# Parallel Execution
#
# Some of the
Applications Concurrent Programs use parallel
# execution including
DBI programs and Gathering Statistics.
#
#########
parallel_max_servers =
8 # Max. value should be 2*CPUs
parallel_min_servers =
0
#########
#
# AIX
#
#########
disk_asynch_io=true
filesystemio_options='SetAll'
2] 11g
###########################################
# Database
Identification
###########################################
db_domain="corp.fr"
db_name="BASE"
compatible=11.2.0.0.0
# 1/ structure
###########################################
# Cache and I/O
###########################################
db_block_size=8192
###########################################
# File Configuration
###########################################
control_files=("/rdo1/base/ctl/cntl_1.ctl",
"/rdo2/base/ctl/cntl_2.ctl")
###########################################
# System Managed Undo
( default )
###########################################
undo_tablespace=UNDOTBS1
###########################################
# Archive
###########################################
log_archive_dest_1='LOCATION=/arch/base/'
log_archive_format='BASE%t_%s_%r.arc'
# 2/ logs
###########################################
# Diagnostics ,
Security and Auditing
###########################################
diagnostic_dest=/work/oracle/base
audit_file_dest=/work/oracle/base/adump
audit_trail=db
remote_login_passwordfile=EXCLUSIVE
os_authent_prefix=''
# 3/ memory
###########################################
# Processes and
Sessions , Cursors and Lib Cache
###########################################
memory_target=348M
processes=300
open_cursors=300
###########################################
# Shared Server
###########################################
DISPATCHERS="(PROTOCOL=tcp)(DISPATCHERS=2)"
# 4/ Divers
###########################################
# AIX
###########################################
disk_asynch_io=true
filesystemio_options='SetAll'
###########################################
# Network Registration
###########################################
#local_listener=LISTENER_BASE
