work process in private mode

[#1]

Dear All,

Our server dialog workprocess goes into private mode during peak usage. We have increased the value of parameter em/initial_size_MB to 10092 also em/blocksize_KB to 10092

But still the problem persists, as we notice all developers use the same userid and there count is more than 20 users.

Can using same userid by developers cause the problem since the workprocess private mode is with there id and userid is shared among all. Please advice

Best Regards,

[nelis]

If it is only certain users that always use too much memory then you should be focusing on what it is they are doing and not trying to make more memory available.

For example, many times I've seen only certain users doing search queries that include all information for a certain date instead of specifying more exact criteria or specific search patterns. So what happens is a lot of unnecessary data is pulled from the database and displayed using up all memory(mostly because people are lazy). That's not to say your developers are doing the same thing.

It would be in your best interest to find out what they are doing that is using so much memory. As soon as you see PRIV processes go to SM04 of the application server and sort by memory usage column, contact those people with excessive high memory usage. It might even be a program error that can be solved with a correction.

Nelis