Configuring system resources for Oracle in SOLARIS10
Wen/Huppis Haratu
Summary:
In this version of SOLARIS10, System resource configuration management has changed significantly compared to previous versions. such as Oracle, in the process of installation, operation, optimization and so on, the system resources (kernel parameters, semaphore, memory space, CPU time, etc.) must be adjusted and set up to be able to run well in large applications, familiar with the Solaris10 of this new resource management methods and mechanisms is very necessary. This article describes the commands and methods for configuring some of the resources used during installation and use of Oracle. To provide references for more Oracle and other similar users.
One,
Preliminary KnowledgeA You can still set the required system resources in the SOLARIS10 in/etc/system. However, many of the parameters that were previously available for setting in this file have been abolished in SOLARIS10. In figure: the item with the * Number can still be set in/etc/system. However, the default values change. See table below:
| Resource Control Identification |
Revocation Options |
old default Value |
Maximum Value |
new Default Value |
| Process.max-msg-qbytes |
Msginfo_msgmnb |
4096 |
Ulong_max |
65536 |
| Process.max-msg-messages |
MSGINFO_MSGTQ L |
40 |
Uint_max |
8192 |
| Process.max-sem-ops |
seminfo_semopm |
10 |
Int_max |
512 |
| Process.max-sem-nsems |
Seminfo_semmsl |
25 |
Shrt_max |
512 |
| Project.max-sem-ids |
Seminfo_semmni |
10 |
224 |
128 |
| Project.max-shm-memory |
Shminfo_shmmax |
0x800000 |
Uint64_max |
1/4 Physical Memory |
| Project.max-shm-ids |
Shminfo_shmmni |
100 |
2 24 |
128 |
| Project.max-msg-ids |
Msginfo_msgmni |
50 |
224 |
128 |
Note: written in
/etc/system
the configuration in the file will not take effect until it is restarted. B You can use the project database to make resource allocation settings for a single process or individual project. The file for the project database is/etc/project. The format is as follows: Projname:projid:comment:user-list:group-list:attributes Where: projname------The given project name ProjId the given project identifier-------- Comment-------Project Description user-list-----The list of users (indicating that the user is using this setting) Group-list the list of----groups (indicating that users of this user group use this setting) Attributes----Setting properties (is key=value pair) * Please refer to reference 1 for more details. C Use Projects,projadd,projmod,projdel,prctl to configure the system resources. Where project is used to view the project parameters that have been configured Projadd used to create project Projmod to modify property values in Project Projdel to delete project Prctl to dynamically set up system resource configuration (increased , delete, change)
Note: Use
proj*
The values you set are automatically written to the
/etc/project
file. and
Prctl
The value you set will be lost after the system restarts (requires a reset). About
proj*
please see the Manual for the use of the command
(
For example:
#man projadd).
Second,
Oracle
The adjustment of system resources inA Set the parameters for Oracle installation using the Proj Series command these parameters in the table that are required to be set up during Oracle installation. The following is a step-by-step setting of these values in the SOLARIS10 below. These values are set by either the root user or a user with the same permissions. (Assuming that an Oracle user has been built)
| Semsys:seminfo_semmni |
Project.max-sem-ids |
100 |
| Semsys:seminfo_semmsl |
Process.max-sem-nsems |
256 |
| Shmsys:shminfo_shmmax |
Project.max-shm-memory |
4294967295 |
| Shmsys:shminfo_shmni |
Project.max-shm-ids |
100 |
A
