Workprocesses goes to on Hold / PRIV mode

[Former Member]

Dear Experts

We have sap ERP ECC6.0 EHP1 under Oracle 12c with Kernel 722 EXT Operating System Suse Enterprise Linux 11SP4

sap system One CI+DB and 2nd dialog instance both are under VMware separate machines

in my dialog instance too many work process goes to on hold/PRIV mode I am unable to resolve it

Please guide me how to resolved it

Best Regards

[Former Member · Accepted solution]

Thank you all for your support and guidance to resolve this issue

We have 2 server ( in VMWARE ) environment server 1 for CI+DB and Server 2 only application server ( Dialog instance ) both servers have 32GB physical memory and 68GB swap space and Operating system Suse linux Enterpriase server 11sp4 with oracle database 12c.

most we are facing an issue in application server

Following screenshot related to application server memory parameters and OS07N

Best Regards

[Former Member · Accepted solution]

[isaias_freitas · Accepted solution]

Hello,

You have "em/initial_size_MB = 9000", which means that the size of the Extended Memory (EM) area is around 9GB.

You also have "ztta/roll_extension = 16106127360" (around 16GB), which would mean that each user can use up to 16GB out of your 9GB EM (?!?!?!).

Increase "em/initial_size_MB" to, let's say, 16000 and reduce "ztta/roll_extension" to 2000000000 (2GB).

Then, see how the system behaves.

Regards,

Isaías

[Former Member]

Hi

In order to avoid PRIV mode, the ABAP code should be optimized by the developer, if it is the customer program. Criteria selection is an important issue while executing the report, also. If the report does not optimized very well, it is inevitable to face with the PRIV mode during the execution.

Secondly, long runtime does not depend to the heap memory (PRIV mode) utilization. It is a result of the not enough free extended memory left on the device, as I noted previously.

In default, the both memory quota levels (extended+heap) have been set to max 2Gb memory allocation. With the 32 Gb physical memory, you can try the parameters, below;

PHYS_MEMSIZE=24576

em/address_space_MB = 8192

ztta/roll_extension_dia = 8192000000

This configuration will configure extended memory to use max 8GB memory. It means that the process will allocate the heap memory when 8GB quota level exceeded.

Regarding the values over the screenshot, the system configured as default. So, a process can be allocated max 4 GB memory. If you configure the parameters I noted above, a process can be used max 12 GB (extended + heap memory)

[isaias_freitas]

Hello,

A dialog work processes enters "priv mode" when the Extended Memory (EM) is exhausted.

You can review the value of the parameter "ztta/roll_extension".

If it is set to a value close to the total EM configured, a singe user could consume the entire EM and all other users would instantly enter "priv mode".

You can also consider increasing the EM size (usually by increasing the parameter "em/total_size_MB". For this you should consider which other systems are running on this server (e.g., does the database also runs on the SAP server?), how much memory is allocated to these other systems, and how much memory (RAM) the server has installed.

Cheers!

Isaías

[Former Member]

Hi,

You have 17 dialog work process and from ST02 your extended memory is way less to accommodate these work processes.

That should be the other reason why they hit heap memory (PRIV mode), try to increase the exnteded memory and monitor the system to see the change.

Regards,

Prithviraj.

[Former Member]

Hello Khizer,

Please refer following link,

Work Process in PRIV Mode | SCN

if this does not resolve your issue.

Please check the following note

2084001 - Many short dumps LOAD_NO_ROLL, many work processes in PRIV mode

Regards

Anand

[Sriram2009]

Hi Khizer.

1. If you know the report or transaction you can enable the ST12 trace check the over all DB & ABAP usage with help ABAPer.

2. On Linux have you define the memory parameters based on the physical memory?

3. Refer the SCN thread with same issue RE: Workprocess in PRIV mode | SCN

Regards

SS