Ansicht
Dokumentation
Tip-No.: 572 ( INFO572 )
DC parameter: init.ora
Tip-No.: 572
( INFO572 )
BAL_S_LOG - Application Log: Log header data
ROGBILLS - Synchronize billing plans
This documentation is copyright by SAP AG.
Short text
DC parameter: init.ora
Tip-No.: 572
Symptom
Database performance.
Cause
DC parameters.
Solution
*************************************************************
* Description: DC parameter init.ora *
*************************************************************
The DC parameters specify the no. of ORACLE Dictionary objects buffered
in the SGA. This information is required via recursive accesses in the
parsing phase of an SQL statement.
The DC parameters occupy at "min" ca. 2 MB in the SGA, at
"max" ca. 14 MB. In between, all parameters can be interpolated
linearly.
Parameter Default SAP-Recommendation
min max
-----------------------------------------------------------------
dc_objects 100 1.600 2.800
dc_used-extents 50 1.000 10.000
dc_tablespaces 25 50 50
dc_object-ids 50 100 1.000
dc_columns 300 10.000 20.000
dc_free-extents 50 1.000 2.000
dc_indexes 50 600 1.600
dc_tables 100 600 1.100
dc_files 25 62 62
dc_segments 50 500 1.000
dc_synonyms 50 100 300
SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up General Material Data
This documentation is copyright by SAP AG.
Length: 1710 Date: 20240425 Time: 064810 sap01-206 ( 15 ms )