Shulou(Shulou.com)05/31 Report--

This article introduces you how to set process in oracle, the content is very detailed, interested friends can refer to, hope to be helpful to you.

1. Due to 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. It will be a problem if the PGA is too small.

3. The setting of process is also related to shared_pool.

Today we mainly analyze the second and third points.

First of all, let's look at the problem of PGA. If we use a dedicated server (DEDICATED) connection, the client establishes a connection, and PGA allocates a certain amount of memory to the session to support the session. So we need to know how much memory a session needs, and then set up the PGA properly to achieve the desired results.

The following is an example where about 2.2m is allocated and about 2m is actually used

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) / coun

(1) / 1024 alloc_avg from v$process

TOTAL_USED USED_AVG TOTAL_ALLOC ALLOC_AVG

--

48146.8887 2006.12036 55651.084 2318.79517

But according to the experience of Daniel, a connection takes up about 10m under PGA 5m under linux, so let's be steady and set a larger PGA for each thread.

Next, let's look at the third point.

If you do not use ASMM or AMM automatic management, if the setting is too large, there may be an error of ORA-00371, and the shared pool setting is too small. If it is set, there will be no error, but it is important to note that the setting of processes is based on demand, because too much setting will result in a waste of shared pools (about 56K http://warehouse.itpub.net/post/777/515882 per process)

Here's process=1500.

SQL > select * from v$sgainfo

NAME BYTES RES

-

Fixed SGA Size 1375792 No

Redo Buffers 5804032 No

Buffer Cache Size 41943040 Yes

Shared Pool Size 469762048 Yes

Large Pool Size 4194304 Yes

Java Pool Size 8388608 Yes

Streams Pool Size 4194304 Yes

Shared IO Pool Size 0 Yes

Granule Size 4194304 No

Maximum SGA Size 535662592 No

Startup overhead in Shared Pool 218103808 No-here

Process=150

SQL > select * from v$sgainfo

NAME BYTES RES

-

Fixed SGA Size 1375792 No

Redo Buffers 5804032 No

Buffer Cache Size 41943040 Yes

Shared Pool Size 469762048 Yes

Large Pool Size 4194304 Yes

Java Pool Size 8388608 Yes

Streams Pool Size 4194304 Yes

Shared IO Pool Size 0 Yes

Granule Size 4194304 No

Maximum SGA Size 535662592 No

Startup overhead in Shared Pool 58720256 No

On how to set up process in oracle to share here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can 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.