Work processes go into PRIV mode

[Former Member]

Hi every body,

All work processes of the SAP System go into the PRIV mode after some time This soon causes long waiting times for all other users,

SAP configuration 4.70 1.10 Kernel its in 1773 patch / Oracle 9.2.0

12Gb RAM . 12 CPU

My prameters profils :

rdisp/wppriv_max_no :3

gw/max_sys : 2000

gw/max_overflow_size : 25000000

rdisp/max_comm_entries : 2000

gw/max_conn : 2000

rdisp/max_arq : 2000

rsdb/obj/max_objects : 20000

sap/bufdir_entries : 10000

rsdb/max_in_blocking_factor : 5

rsdb/min_in_blocking_factor : 5

rsdb/obj/buffersize : 20000

rdisp/max_wprun_time : 3600

abap/timeout : 3600

rdisp/tm_max_no : 2000

rdisp/gui_auto_logout : 3600

login/no_automatic_user_sapstar : 1

login/password_expiration_time : 60

login/min_password_specials : 1

login/min_password_digits : 1

login/min_password_lng : 8

login/fails_to_user_lock : 3

em/global_area_MB : 255

login/failed_user_auto_unlock : 0

login/system_client : 200

SAPSYSTEMNAME : P11

INSTANCE_NAME : DVEBMGS00

SAPSYSTEM : 00

rdisp/wp_no_dia : 20

rdisp/wp_no_btc : 7

rdisp/wp_no_vb : 7

rdisp/wp_no_vb2 : 2

rdisp/wp_no_enq : 1

rdisp/wp_no_spo : 2

ipc/shm_permission_01 : 10740

ipc/shm_permission_02 : 10740

ipc/shm_permission_03 : 10740

ipc/shm_permission_16 : 10740

ipc/shm_permission_31 : 10740

ipc/shm_permission_52 : 10740

ipc/shm_permission_62 : 10740

DIR_TRANS : /usr/sap/trans

icm/server_port_0 : PROT=HTTP,PORT=8000,EXTBIND=1

DIR_ORAHOME : /oracle/P11/920_64

abap/buffersize : 600000

zcsa/table_buffer_area : 30000128

rtbb/buffer_length : 10000

rsdb/cua/buffersize : 5000

zcsa/presentation_buffer_area : 20000768

rdisp/appc_ca_blk_no : 2000

rdisp/wp_ca_blk_no : 1000

rsdb/ntab/entrycount : 20000

rsdb/ntab/ftabsize : 30000

rsdb/ntab/irbdsize : 6000

rsdb/ntab/sntabsize : 3000

DIR_ROLL : /usr/sap/P11/DVEBMGS00/data

DIR_PAGING : /usr/sap/P11/DVEBMGS00/data

rec/client : 200

DIR_DATA : /usr/sap/P11/DVEBMGS00/data

DIR_REORG : /usr/sap/P11/DVEBMGS00/data

DIR_TEMP : /tmp

DIR_SORTTMP : /usr/sap/P11/DVEBMGS00/data

zcsa/second_language : E

zcsa/system_language : F

zcsa/installed_languages : EFD

install/codepage/appl_server : 1100

abap/use_paging 0

ztta/roll_first :1024

ztta/roll_area : 3000320

rdisp/ROLL_SHM : 16384

rdisp/ROLL_MAXFS : 32768

rdisp/PG_SHM : 8192

rdisp/PG_MAXFS : 32768

abap/heap_area_dia : 2000683008

abap/heap_area_nondia : 2000683008

abap/heap_area_total : 2000683008

abap/heaplimit : 408944640

abap/swap_reserve : 20971520

ztta/roll_extension : 2000683008

em/initial_size_MB : 4092

em/blocksize_KB : 4096

em/stat_log_size_MB : 20

em/stat_log_timeout : 0

ipc/shm_psize_10 : 34000000

ipc/shm_psize_14 : 0

ipc/shm_psize_18 : 0

ipc/shm_psize_19 : 0

ipc/shm_psize_30 : 0

ipc/shm_psize_41 : 0

enque/table_size : 32000

ipc/shm_psize_40 : 6000000

Help me please

Thanks

FK

[Former Member · Accepted solution]

Thanks Ben,

Another question i have 12Gb in memory RAM

This parametrs with this value its ok

em/initial_size_MB : 4092

With transaction ST02 i have two problems

Extended Memory in 93,44% (ztta/roll_first :1024 its responsible for this problem

SWAP

Nametab (NTAB)

Intial records 41 in red color

Tables

Generic key 182 in red color

Single record 56 in red color

Thanks

FK

[Former Member · Accepted solution]

Hi

yes ...

change the parameter ztta/roll_first =1 ....it will be fine ...

Regards

Ben

[Former Member · Accepted solution]

Thank you very much Ben

[Former Member · Accepted solution]

Hi,

You forgot reward points.

Regards

Ben

[Former Member · Accepted solution]

Hi,

Are you satisfy,

At a next discussion

Regards

FK

[Former Member]

Problem resolved

[Former Member]

What was the final solution?

[Former Member]

I had a problem in the extended memory the heap memory and the swap, I just adjusted these parameters

zcsa/db_max_buftab 10000

rdisp/max_priv_time 600

rdisp/wppriv_max_no 6

gw/max_sys 2000

gw/max_overflow_size 25000000

rdisp/max_comm_entries 2000

gw/max_conn 2000

rdisp/max_arq 2000

rsdb/obj/max_objects 20000

sap/bufdir_entries 10000

rsdb/obj/buffersize 20000

rdisp/tm_max_no 2000

zcsa/table_buffer_area 50000000

rtbb/buffer_length 30000

rsdb/cua/buffersize 5000

zcsa/presentation_buffer_area 20000768

rdisp/appc_ca_blk_no 2000

rdisp/wp_ca_blk_no 1000

rsdb/ntab/entrycount 30000

rsdb/ntab/ftabsize 39000

rsdb/ntab/irbdsize 9500

ztta/roll_first 1

ztta/roll_area 6500000

rdisp/ROLL_SHM 32768

rdisp/ROLL_MAXFS 65536

rdisp/PG_SHM 16384

ipc/shm_psize_10 38000000

ipc/shm_psize_40 86000000

[Former Member]

Hi Farid,

I suggest that you update your oracle patch to atleast 7.0.

9.2.0.1 is not supported and has loads of overheads...

[Former Member]

The problem persist after 3 hours of work

[Former Member]

Hi every body,

Sorry but my problem it's not yet resolved, after change of profil parameter

ztta/rool_first = 1 ... A Work processes go always into PRIV mode

in st02 the extended memory is at 100 %

Actual parameter for extended memory is :

Please help me if actual parameter it's correct I have 12Gb in RAM

Roll, extended and heap memory

ztta/roll_area 3000320

ztta/roll_first 1

ztta/short_area 1600000

rdisp/ROLL_SHM 16384

rdisp/PG_SHM 8192

rdisp/PG_LOCAL 150

em/initial_size_MB 4092

em/blocksize_KB 4096

em/address_space_MB 4092

ztta/roll_extension 2000683008

abap/heap_area_dia 2000683008

abap/heap_area_nondia 2000683008

abap/heap_area_total 2000683008

abap/heaplimit 408944640

abap/use_paging 0

[Former Member]

Hello Farid,

memory parameters wont be of too much of help. Further the parameter suggested by Ben control the initial roll memory assigned to dialog process. While 1 is SAP suggested value and in your case also it should be 1 it wont solve this issue. This parameter is responsible for first step of memory allocation.

When a work process go into priv mode then it is is assigned dedicatedly to a single user and infact this is last step of memory allocation.

Solution:

You need to add this parameter to your profile

rdisp/max_priv_time

For rdisp/max_priv_time set te value to 600 . There is another parameter rdisp/wppriv_max_no set a suitable vlaue. Currently it is 3. Its value can be around one third of total number of dialog processes but this is your choice. We are following this one third approach in our systems.

In our case rdisp/wppriv_max_no was the clinching factor. But in your case I think it would be rdisp/max_priv_time.

There is an OSS note 79435 which explains about priv mode. It also mentions another parameter rdisp/max_debug_lazy_time.

Please do check this note.

Please award points if issue was solved.

Regards.

Ruchit.

[Former Member]

Thank very much for your help

Regards

FK

[Former Member]

Hello Farid,

Is your problem solved?

regards.

Ruchit.

[Former Member]

I think it's ok... Just a few times to observe

Regards

FK

[Former Member]

All right let us know. Interested in knowing if the time parameter really helped. Also let me know what value of the parameter finally worked.

Regards.

Ruchit.

[Former Member]

Hi,

Could you please let me know environment details (OS,database and SAP version).

Regards

Ben

[Former Member]

Hi,

OS : HPUX 11.2

SAP Component SAP R/3 ENTERPRISE

Release 47x200

DB System ORACLE 9.2.0.1

Ragards

FK

[Former Member]

Hi,

The following parameter is wrong ...change to 1... I am sure your problem will resolved.

ztta/roll_first :1024

Regards

Ben