Shulou(Shulou.com)06/02 Report--

I won't say much about the role of the process parameter here, and now I'll mainly talk about the problems that you need to pay attention to if you want to increase the process value.

1 accept the limitation of operating system parameters, the nproc parameters used by oracle users in the operating system should be large enough, otherwise it is useless to set process too large.

2 check the size of the oracle database pga. If the PGA is too small, there will be a problem. How to reprint an article on the Internet?

When we manage the amount of memory allocated by processes and pga, we usually take into account the size of each process, and then decide how big our PGA allocation is and how big our processes is.

So how to check the amount of memory occupied by a connection

When the client establishes a connection and the database creation process, can you find out the amount of memory occupied by a connection?

Can be queried through v$processes

SQL > select sum (pga_used_mem) / 1024 total_used, sum (pga_used_mem) / count (1) / 1024 used_avg, sum (pga_alloc_mem) / 1024 total_alloc, sum (pga_alloc_mem) / count (1) / 1024 alloc_avg from v$process

TOTAL_USED USED_AVG TOTAL_ALLOC ALLOC_AVG

--

60971.5898 1847.62393 142401.8125 4315.20643

As you can see here, about one allocation is about 5m, each using 2m.

Here my record number is 32, through here we can see that 60m has been used and 140m has been allocated, so if the process is 150m, our PGA should be set to at least 500m to support our system.

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.