Ansicht
Dokumentation

Static init.ora parameters
Tip-No.: 574 ( INFO574 )

Short text

Static init.ora parameters
Tip-No.: 574

Symptom

Database performance.

Cause

Changing init.ora parameters.

Solution

*****************************************************************
* Static init.ora parameters *
*****************************************************************

These parameters may not be changed.

Parameter Default SAP- Recommend.
----------------------------------------------------------------------

db_files 32 files 62
db_file_multiblock_read_count O/S dependent 32
db-block-write-batch 8 blocks 16
max_dump_file_size 500 blocks 5000
row_cache_enqueues 100 3000
row_cache_cursors 10 300
row_locking ALWAYS/INTENTALWAYS
free_list_proc 1 1
row_cache_cursors 10 100
transaction_per_rollback_segment 20 10
audit_trail false False

Comments:

- free_list_proc
This parameter only takes effect when a table is first created.
- audit_trail
For audit_trail = TRUE, sessions = 2.1*processes must be set.
Warning: heavy resource consumption.