In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-01-19 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)05/31 Report--
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.
Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.