Tuning HP Tru64 UNIX V5.1A and V5.1B for Oracle

13
The default value of the attribute is 5000; therefore, the maximum number of outgoing connections is,
by default, 3976 (5000 – 1024).
On systems with a large number of connections, this value should be raised.
On TruCluster Server configurations that do not use Memory Channel as the cluster interconnect, this
value should be raised to 65536.
The recommended value for ipport_userreserved on large-scale Oracle installations should be
the maximum value of 65535.
PROC Subsystem
The following tunable parameters should be set in the proc subsystem section of
/etc/sysconfigtab. Most of the parameters described in the following sections are limits that
specify the amount of address space resources that processes are allowed to use. All of those
parameter’s names take the form of per_proc and max_per_proc. By default, all of these
processes can grow their address space resources up to the limit specified by the per_proc
parameter. It is possible to allow processes resource requirements to grow up to the size specified in
the max_per_proc parameter by using the limit or ulimit shell commands. In order to allow the
maximum resources for Oracle processes, you can specify the required command in the login script
for the Oracle user. Alternatively, you can make the per_proc and max_per_proc parameter
settings identical. This can safely be done on database servers where processes will never use an
unexpected amount of address space resources.
per_proc_stack_size and max_per_proc_stack_size
This tunable parameter specifies the per process stack size in bytes. The default values of 8 MB and
32 MB for this tunable are usually large enough for most Oracle environments. However, in very
large installations and data warehouse-type environments the value should be increased.
Depending on the Oracle environment, the maximum stack size can be increased to a maximum of
896 MB. This limit is due to the fact that Oracle has fixed the PGA and SGA to start at 0x38000000
and 0x58000000, respectively, for performance (this only applies to the Tru64 UNIX port). If you use
a value larger than 896 MB for this parameter, Oracle could corrupt the fixed SGA and PGA.
The recommended value for per_proc_stack_size is 33554432 (32 MB).
The recommended value for max_per_proc_stack_size is 536870912 (512 MB).
per_proc_data_size and max_per_proc_data_size
This tunable parameter specifies the default per process data size in bytes. The following value will set
this tunable parameter to the amount of physical memory installed on the system. It is possible to raise
the value to a value larger than actual memory available. However, this would allow a single process
to outgrow a system’s main memory and cause extensive swapping and paging.
It is highly recommended to stay within the bounds of the available memory for this tunable
parameter, and never raise the tunable parameter to a value larger than the physical memory
available plus the configured swap space.
The recommended maximum value for per_proc_data_size is 0x40000000000.
The recommended value for max_per_proc_data_size is to set it to the same value as
per_proc_data_size with a maximum of 0x40000000000.
per_proc_address_space and max_per_proc_address_space
This tunable parameter specifies the per process address size in bytes. This parameter needs to be
large enough to account for the size of the virtual address space (including the dynamically allocated
memory and the SGA) of the largest process in the system. It is possible to raise the value to a larger