Als PDF Downloaden!

Init.ora für 8.1.7 Linux

##############################################################################
# Initialisierungsdatei init.ora für Oracle DB
# Betriebssystem: SUSE Linux
# Oracle Version: 8.1.7.4
# Marco Patzwahl MuniQSoft GmbH 2003-2009
# www.muniqsoft.de
# Version 2.0.5 vom 21.4.2009
# Hinweis:Diese Initialisierungsdatei soll als Vorlage dienen.
#        Sie wird jedoch nicht für alle Installationen passen.
#        Unser Consulting Team unterstützt Sie gerne entweder
#        bei Ihnen vor Ort oder über unseren Remote-Support.
#        Telefon: 089 /6228 6789-0
#        Email: info@muniqsoft.de
##############################################################################

# Globaler Datenbankname = db_name.db_domain
# ------------------------------------------
db_name                          =  orcl
db_domain                        =  muniqsoft.de
global_names                     =  FALSE

# Instanzinformationen
# -------------------------------
instance_name                    =  orcl
service_names                    =  orcl

# Basis Parameter
# ------------------------------
compatible                       =  8.1.7.4
db_block_size                    =  8192
db_files                         =  64
control_files                    =  /u01/oracle/oradata/orcl/orcl_control01.con,
                                    /u01/oracle/oradata/orcl/orcl_control02.con
control_file_record_keep_time     = 32

# SGA, I/O
# ------------------------------
# Database Buffer Cache Größe ist 8000 * 8192 = 62 MB
db_block_buffers                 =  8000
#buffer_pool_keep                  =  200
#buffer_pool_recycle             =  100
db_block_lru_latches             =  3
db_file_multiblock_read_count    =  16

shared_pool_size                  = 200000000
java_pool_size                    = 100000000

# Databank Block Prüfung
# -----------------------
db_block_checking                 = true
db_block_checksum                 = false

# Checkpointing
# -------------
log_checkpoint_interval           =  0
log_checkpoint_timeout            =  0
log_checkpoints_to_alert          =  true

# REDO Logging
# ------------
log_buffer                        =  1024000
log_archive_start                 =  true
log_archive_format                =  archive_%s.arl

# Multiplexing REDO Logging
# ----------------------
log_archive_dest_1                = "location=/u01/oracle/oradata/orcl/arc1 mandatory reopen=300"
# log_archive_dest_2                = "location=/u01/oracle/oradata/orcl/arc2 mandatory reopen=300"
# log_archive_dest_3                = "location=/u01/oracle/oradata/orcl/arc3 mandatory reopen=300"
# log_archive_dest_4                = "location=/u01/oracle/oradata/orcl/arc4 optional reopen=300"
# log_archive_dest_5                = "location=/u01/oracle/oradata/orcl/arc5 optional reopen=300"
# log_archive_min_succeed_dest      = 1

# Rollback Segmente
# -------------------
rollback_segments                 = (rbs01,rbs02,rbs03,rbs04,rbs05,rbs06,rbs07,rbs08)
transactions_per_rollback_segment = 10
transactions                      = 300

# SQL Processing, Optimizer, Sequences
# ------------------------------------
open_cursors                      =  512
cursor_space_for_time             =  false
optimizer_mode                    =  choose
partition_view_enabled            =  true
hash_join_enabled                 =  true

# Sortierung
# -----------
sort_area_retained_size           =  128000
sort_area_size                    =  512000

# Traces, Dumps & Statistics
# --------------------------
user_dump_dest                    =  /u01/oracle/oradata/orcl/udump
background_dump_dest              =  /u01/oracle/oradata/orcl/bdump
core_dump_dest                    =  /u01/oracle/oradata/orcl/cdump
# utl_file_dir Verzeichnis muss angelegt werden
utl_file_dir                      =  /u01/oracle/oradata/orcl/utlfile
max_dump_file_size                =  32768
_trace_files_public               =  true
sql_trace                         =  false
timed_statistics                  =  true

# Resource Limiter, Security & Auditing
# -------------------------------------
sql92_security                    =  true
resource_limit                    =  true
#audit_trail                       =  db
max_enabled_roles                 =  128
os_authent_prefix                 =  "OPS$"
os_roles                          =  false
remote_os_roles                   =  false
remote_os_authent                 =  true
remote_login_passwordfile         =  exclusive
o7_dictionary_accessibility       =  false

# Job Queues
# ----------
job_queue_processes               =  5

# Prozesse, Transaktionen, User Lizenzen, Locks
# ----------------------------------------------
processes                         =  115
open_links                        =  32
license_max_sessions              =  0
license_sessions_warning          =  0
enqueue_resources                 =  4096
aq_tm_processes                   =  1

# Parallel Query Option
# ---------------------
parallel_min_servers              =  2
parallel_max_servers              =  5                   

# Query Rewrite für Materialized Views, Function based Indexes (FBI)
# ------------------------------------------------------------
# query_rewrite_integrity = [enforced,trusted,stale_tolerated]
query_rewrite_enabled             = true
query_rewrite_integrity           = stale_tolerated
star_transformation_enabled       = false

# NLS Default Einstellungen
# --------------------
nls_date_format                   = 'DD.MM.YYYY:HH24:MI'
nls_numeric_characters            = '.,'
nls_language                      =  GERMAN
nls_territory                     =  GERMANY

Suche