How to estimate the maximum values of process and session parameters

This article will explain in detail how to estimate the maximum values of process and session parameters. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

Session and process consume PGA.

In online systems, PGA is generally 30% of memery_target. Specific parameters session and process can be set. The memory value of an average process can be obtained according to the avg_used_M of the following statement. By combining this value with the size of PGA, the maximum values of parameters session and process can be calculated.

Select round (sum (pga_used_mem) / 1024comp1024re0) total_used_M, round (sum (pga_used_mem) / count (1) / 1024comp1024dy0) avg_used_M

Round (sum (pga_alloc_mem) / 1024comp1024re0) total_alloc_M, round (sum (pga_alloc_mem) / count (1) / 1024comp1024dy0) avg_alloc_M from v$process

The value of the oracle parameter process cannot be greater than the oracle soft nproc value in / etc/security/limits.conf.

And session=1.1*process+5

When evaluating how much pga is appropriate, you can refer to the PGA Target Est (MB) value corresponding to the first line of Estd PGA Overalloc Count=0 in AWR where PGA Memory Advisory appears from top to bottom.

This is the end of the article on "how to estimate the maximum values of process and session parameters". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it for more people to see.