on 12-18-2008 6:16 AM
Hello,
We have just upgraded RAM of our hp-ux server.
Edited by: Chandresh Pranami on Dec 18, 2008 11:52 AM
Hello,
We have just upgraded RAM of our hp-ux server.
OS : HP UX 11.23
SAP ECC 6.0
Now which are the oracle and sap parameters should we change in server?
Thanks,
Chandresh Pranami
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
init<SID>.ora
-
########################################################################
This init.ora profile is a transparent copy of Oracle spfile. #
It was created by BRCONNECT at 2008-12-18 23.30.47. #
Please do not change this file! Maintain only the spfile. #
You can use BRSPACE for the altering of database parameters: #
brspace -f dbparam #
########################################################################
*._OPTIM_PEEK_USER_BINDS=FALSE
*.background_dump_dest='/oracle/AWD/saptrace/background'
*.compatible='10.2.0'
*.control_file_record_keep_time=30
*.control_files='/oracle/AWD/origlogA/cntrl/cntlrAWD.dbf','/oracle/AWD/origlogB/cntrl/cntrlAWD.dbf','/oracle/AWD/sapdata1/cntrl/cntrlAWD.dbf'
*.core_dump_dest='/oracle/AWD/saptrace/background'
*.db_block_size=8192
*.db_cache_size=288211599
*.db_files=254
*.db_name='AWD'
*.dml_locks=4000
*.event='10191 trace name context forever, level 1'
*.FILESYSTEMIO_OPTIONS='setall'
*.job_queue_processes=1
*.log_archive_dest='/oracle/AWD/oraarch/AWDarch'
*.log_buffer=1048576
*.log_checkpoint_interval=0
*.log_checkpoints_to_alert=true
*.open_cursors=800
*.optimizer_features_enable='10.2.0.1'
*.pga_aggregate_target=384282132
*.processes=80
*.recyclebin='off'
*.remote_login_passwordfile='exclusive'
*.remote_os_authent=true
*.sessions=96
*.sga_max_size=576423198
*.shared_pool_reserved_size=28821159
*.shared_pool_size=288211599
*.sort_area_retained_size=0
*.sort_area_size=2097152
*.statistics_level='typical'
*.undo_management='AUTO'
*.undo_retention=43200
*.undo_tablespace='PSAPUNDO'
*.user_dump_dest='/oracle/AWD/saptrace/usertrace'
*.workarea_size_policy='AUTO'
________________________________________________________________________________
INSTANCE profile
________________________________________________________________________________
________________________________________________________________________________
#.******************************************************************************************************************************
#.* *
#.* Instance profile AWD_DVEBMGS00_LAKSHYA *
#.* *
#.* Version = 000009 *
#.* Generated by user = BASIS *
#.* Generated on = 02.08.2008 , 00:39:20 *
#.* *
#.******************************************************************************************************************************
#parameter created by: BASIS 20.06.2008 09:42:44
login/min_password_lng = 3
#parameter created by: BASIS 02.04.2008 11:09:45
rdisp/max_alt_modes = 3
#parameter created by: BASIS 02.04.2008 11:09:26
#old_value: 1800 changed: BASIS 02.08.2008 00:38:58
rdisp/max_wprun_time = 3000
#parameter created by: DDIC 25.03.2008 10:50:46
login/no_automatic_user_sapstar = 0
SAPSYSTEMNAME = AWD
SAPSYSTEM = 00
INSTANCE_NAME = DVEBMGS00
DIR_CT_RUN = $(DIR_EXE_ROOT)/run
DIR_EXECUTABLE = $(DIR_INSTANCE)/exe
PHYS_MEMSIZE = 512
exe/saposcol = $(DIR_CT_RUN)/saposcol
#old_value: 6 changed: DDIC 25.03.2008 10:52:31
#old_value: 9 changed: BASIS 16.04.2008 12:30:21
rdisp/wp_no_dia = 8
#old_value: 3 changed: DDIC 28.03.2008 00:56:48
#old_value: 5 changed: BASIS 31.03.2008 15:08:37
#old_value: 3 changed: BASIS 16.04.2008 12:30:21
rdisp/wp_no_btc = 6
exe/icmbnd = $(DIR_CT_RUN)/icmbnd
icm/server_port_0 = PROT=HTTP,PORT=80$$
#----
SAP Messaging Service parameters are set in the DEFAULT.PFL
#----
ms/server_port_0 = PROT=HTTP,PORT=81$$
rdisp/wp_no_enq = 1
#old_value: 1 changed: DDIC 25.03.2008 10:52:31
rdisp/wp_no_vb = 2
rdisp/wp_no_vb2 = 1
rdisp/wp_no_spo = 1
#parameter created by: DDIC 25.03.2008 10:52:31
abap/buffersize = 350000
#parameter created by: DDIC 25.03.2008 10:52:31
zcsa/table_buffer_area = 40240128
#parameter created by: DDIC 25.03.2008 10:52:31
rtbb/buffer_length = 20000
#parameter created by: DDIC 25.03.2008 10:52:31
rsdb/cua/buffersize = 4000
#parameter created by: DDIC 25.03.2008 10:52:31
zcsa/presentation_buffer_area = 8496128
#parameter created by: DDIC 25.03.2008 10:52:31
rdisp/appc_ca_blk_no = 100
#parameter created by: DDIC 25.03.2008 10:52:31
rdisp/wp_ca_blk_no = 300
#parameter created by: DDIC 25.03.2008 10:52:31
#old_value: 28826 changed: DDIC 28.03.2008 00:56:48
#old_value: 28819 changed: BASIS 31.03.2008 15:08:37
#old_value: 28806 changed: BASIS 16.04.2008 12:30:21
rsdb/ntab/entrycount = 28793
#parameter created by: DDIC 25.03.2008 10:52:31
#old_value: 43263 changed: DDIC 28.03.2008 00:56:48
#old_value: 43265 changed: BASIS 31.03.2008 15:08:37
#old_value: 43267 changed: BASIS 16.04.2008 12:30:21
rsdb/ntab/ftabsize = 43269
#parameter created by: DDIC 25.03.2008 10:52:31
rsdb/ntab/irbdsize = 8653
#parameter created by: DDIC 25.03.2008 10:52:31
rsdb/ntab/sntabsize = 4326
#parameter created by: DDIC 25.03.2008 10:52:31
DIR_ROLL = /usr/sap/AWD/DVEBMGS00/data
#parameter created by: DDIC 25.03.2008 10:52:31
DIR_PAGING = /usr/sap/AWD/DVEBMGS00/data
#parameter created by: DDIC 25.03.2008 10:52:31
DIR_DATA = /usr/sap/AWD/DVEBMGS00/data
#parameter created by: DDIC 25.03.2008 10:52:31
DIR_REORG = /usr/sap/AWD/DVEBMGS00/data
#parameter created by: DDIC 25.03.2008 10:52:31
DIR_TRANS = /usr/sap/trans
#parameter created by: DDIC 25.03.2008 10:52:31
DIR_TEMP = /tmp
#parameter created by: DDIC 25.03.2008 10:52:31
DIR_SORTTMP = /usr/sap/AWD/DVEBMGS00/data
#parameter created by: DDIC 25.03.2008 10:52:31
zcsa/system_language = E
#parameter created by: DDIC 25.03.2008 10:52:31
zcsa/installed_languages = ED
#parameter created by: DDIC 25.03.2008 10:52:31
install/codepage/appl_server = 4102
#parameter created by: DDIC 25.03.2008 10:52:31
abap/use_paging = 0
#parameter created by: DDIC 25.03.2008 10:52:31
ztta/roll_first = 1024
#parameter created by: DDIC 25.03.2008 10:52:31
ztta/roll_area = 3000320
#parameter created by: DDIC 25.03.2008 10:52:31
rdisp/ROLL_SHM = 16384
#parameter created by: DDIC 25.03.2008 10:52:31
rdisp/ROLL_MAXFS = 32768
#parameter created by: DDIC 25.03.2008 10:52:31
rdisp/PG_SHM = 8192
#parameter created by: DDIC 25.03.2008 10:52:31
rdisp/PG_MAXFS = 32768
#parameter created by: DDIC 25.03.2008 10:52:31
abap/heap_area_dia = 2000683008
#parameter created by: DDIC 25.03.2008 10:52:31
abap/heap_area_nondia = 2000683008
#parameter created by: DDIC 25.03.2008 10:52:31
abap/heap_area_total = 2000683008
#parameter created by: DDIC 25.03.2008 10:52:31
abap/heaplimit = 40894464
#parameter created by: DDIC 25.03.2008 10:52:31
abap/swap_reserve = 20971520
#parameter created by: DDIC 25.03.2008 10:52:31
ztta/roll_extension = 2000683008
#parameter created by: DDIC 25.03.2008 10:52:31
em/initial_size_MB = 4092
#parameter created by: DDIC 25.03.2008 10:52:31
em/blocksize_KB = 4096
#parameter created by: DDIC 25.03.2008 10:52:31
em/stat_log_size_MB = 20
#parameter created by: DDIC 25.03.2008 10:52:31
em/stat_log_timeout = 0
#----
#Values proposed by SAP for shared memory pool sizes
#----
#parameter created by: DDIC 25.03.2008 10:52:37
ipc/shm_psize_10 = 124000000
#parameter created by: DDIC 25.03.2008 10:52:37
ipc/shm_psize_14 = 0
#parameter created by: DDIC 25.03.2008 10:52:37
ipc/shm_psize_18 = 0
#parameter created by: DDIC 25.03.2008 10:52:37
ipc/shm_psize_19 = 0
#parameter created by: DDIC 25.03.2008 10:52:37
ipc/shm_psize_30 = 0
#parameter created by: DDIC 25.03.2008 10:52:37
ipc/shm_psize_40 = 138000000
#parameter created by: DDIC 25.03.2008 10:52:37
ipc/shm_psize_41 = 0
-
Previously RAM was 2 GB and now its 6 GB.
Thanks,
Chandresh Pranami
User | Count |
---|---|
83 | |
10 | |
10 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.