The size of the shared memory segment (shm-max) dictates how
large you can make the SGA (db_block_buffers and shared_pool_size comprise
the bulk of the SGA). The total number of semaphores (num-of-sems) dictate
how
many Oracle processes (cumulative of *all* instances) can be specified by
the init.ora parameter: processes.
Since the semaphore parameters are interrelated, make sure the other
semaphore parameters are in-tune with the total number of semaphores
defined. You'll want to monitor your buffer cache and other hit ratios and
tune as
needed. Would recommend picking up a copy of Oracle Performance Tuning, 2nd
Edition, O'Reilly. Hope this helps.
--
Jim Wadas
Information Technology Solutions and Services (ITSS)
Motorola Systems Solutions Group (SSG)
Scottsdale, AZ 85257
(480) 441-8196
Jim.Wadas_at_motorola.com
Feher Lajos wrote in message <80c85e$855$1_at_newsgate.elender.hu>...
>Here is some rows from sysconfigtab file.
>Alpha 4100, 2CPU, 2GB Ram. This is a test machine, and we running some
>instance on it with very good performance.
>The install doc is a very good staff to change and set kernel parameters.
If
>you have Digital documentation you should search for kernel parameters and
>its descriptions.
>I follow Oracle suggestions to set proc, ipc and dlm section.
>In vm section we modified the filesystem cache parameters.
>
>proc:
> max-threads-per-user = 2048
> max-proc-per-user = 1024
> task-max = 2048
> thread-max = 4096
>
>ipc:
> msg-max = 16384
> msg-mnb = 32768
> msg-mni = 1024
> msg-tql = 4096
> shm-max = 1073741824
> sem-mni = 200
> num-of-sems = 200
> sem-msl = 200
> sem-opm = 200
> sem-ume = 200
>
>vm:
> ubc-maxpercent=30
> vm-page-free-target=512
> vm-page-free-swap=150
> vm-page-free-min=40
>
>dlm:
> dlm_disable_grptx = 0
>
>feherl
>
>Tapan Trivedi wrote in message <382A36BA.A5DBAB34_at_abbnm.com>...
>>Hey guys,
>>I am looking for some direction here . My manager has asked me to
>>research what kernel parameters we could manipulate for improving the
>>performance. Could someone give me some pointers on the same please ?
>>The version is Oracle 7.3.2 and 7.3.4 on Digital UNIX 4.0. Any hints
>>,comments,suggestions are welcome. Would also appreciate it if you could
>>cc to my e-mail address.
>>
>>
>>Thanks a lot for your time.
>>
>>
>>Tapan H Trivedi
>>
>
>
Received on Wed Nov 10 1999 - 16:37:56 CST
