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

This article is to share with you about AIX installation Oracle 11g RAC memory and network parameters, the editor thinks it is very practical, so I share it with you to learn. I hope you can get something after reading this article. Let's take a look at it with the editor.

1. Virtual memory parameters

The recommended values for IBM are:

Minperm%=3

Maxperm%=90

Maxclient%=90

Lru_file_repage=0

Strict_maxperm=0

Strict_maxclient=1

Page_steal_method=1

The minimum amount of memory that minperm%: should use to cache non-computational pages

The maximum amount of memory that maxperm%: should use to cache non-computational pages

Maxclient%: should be used to cache the maximum amount of memory for non-computational client pages. Because all non-computational client pages are a subset of the total number of non-computational persistent storage pages, the maxclient limit must always be less than or equal to the maxperm limit. The vmstat-v command displays the system's numclient value as a percentage of the system's actual memory.

Lru_file_repage = 0: when numperm is between minperm and maxperm, the AIX kernel always chooses non-computational paging.

Strict_maxperm=0: set to a non-strict limit, which allows more non-computational files to be cached in memory when free memory is available. The vmstat-v command displays the system's numperm value as a percentage of the system's actual memory.

The strict_maxclient=1:AIX kernel does not allow non-computational client file caching to exceed the maxclient limit. When numclient reaches the maxclient limit, the AIX kernel starts paging replacement in a special, client-only mode.

Page_steal_method: if page_steal_method = 1, list-based LRU algorithm will be used; if page_steal_method = 0, physical-address-based scanning will be used.

Setting method:

#! / usr/bin/ksh

Vmo-p-o parameter= [value]

two。 Network parameters

Tcp_recvspace = 65536

Tcp_sendspace = 65536

Udp_sendspace = (DB_BLOCK_SIZE * DB_MULTIBLOCK_READ_COUNT) + 4 KB) but no lower than 65536

Udp_recvspace = 655360 (Minimum recommended value is 10x udp_sendspace, parameter value must be less than sb_max)

Rfc1323 = 1

Sb_max = 4194304

Ipqmaxlen = 512

Tcp_recvspace: how many bytes of data the receiving system can buffer in the kernel on the receiving socket queue. TCP uses it to limit how many bytes of data are sent to the receiver, ensuring that the receiver has enough space to buffer the data. The tcp_recvspace tunable parameter is a key parameter for TCP performance because TCP must be able to deliver multiple packets to the network to ensure that the network pipeline is full. If TCP fails to keep enough packets in the pipeline, performance will suffer.

Tcp_sendspace: before blocking the application before sending the call, the tcp_sendspace tunable parameter specifies how much data the sending application can buffer in the kernel.

Udp_sendspace: set to be equal to or greater than the value of the largest UDP Datagram to be sent. For installation of GI version 11.2.0.2, failure to set up udp_sendspace will cause root.sh to fail. See Document 1280234.1.

Udp_recvspace: controls the amount of space for incoming data arranged on each UDP socket. Once the socket reaches the udp_recvspace limit, the inbound package is discarded.

Rfc1323: enables the TCP window zoom option. The TCP window scaling option is negotiated by TCP, so it must be enabled at both ends of the TCP connection for it to take effect. By default, the TCP window size is limited to 65536 bytes (64 K), but if you set the rfc1323 value to 1, you can set it higher. If you set the tcp_recvspace value to greater than 65536, set the rfc1323 value to 1 on each side of the connection. If the rfc1323 value is not set on both sides of the connection, the valid value of the tunable parameter in tcp_recvspace will be 65536.

Sb_max: set an upper limit on the number of socket buffers queued to individual sockets so that you can control how much cache space is consumed by the socket buffers queued to the sender or receiver.

Ipqmaxlen: controls the length of the IP input queue. In general, interfaces are not queued. Packets can arrive quickly, causing the IP layer input queue to exceed the limit. You can use the netstat-s or netstat-p ip commands to view the overflow count (ipintrq overflows). If the returned value is greater than 0, an overflow occurs.

Setting method:

No-o parameter= [value]

These are the AIX installation Oracle 11g RAC memory and network parameters. The editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.

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.