SAP® Documentation

Single view

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

ROGBILLS - Synchronize billing plans   BAL Application Log Documentation  
This documentation is copyright by SAP AG.
SAP E-Book

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.






BAL Application Log Documentation   rdisp/max_wprun_time - Maximum work process run time  
This documentation is copyright by SAP AG.

Length: 1655 Date: 20191024 Time: 014922     sap01-206 ( 26 ms )

Our Service

Looking for Support? Questions?

The

Consolut

Callback-Service

Leave us your contact details and we will call you back. Panels marked with * are mandatory.