The article below discusses how to tune Oracle parameters for performance,
but your request is regarding kernel parameters, right? You'll need to
research the system-level parameters relative to the shared memory segment
and system semaphores. The size of the shared memory segment 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 you define dictate how
many Oracle processes can be specified by the init.ora parameter: processes.
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
Gazza wrote in message
<942252521.27557.0.nnrp-13.c1ed75d0_at_news.demon.co.uk>...
>Main ones to look at are
>
>SHARED_POOL_SIZE
>DB_BLOCK_BUFFERS
>LOG_BUFFER
>SORT_AREA_SIZE
>
>Could go on for a while but it's best to get familiar with these four first
>as in my experience these are where you get your quick wins unless you are
>experiencing problems outside of just SGA utilisation
>
>
>--
>Gary Waldrom
>Amonra Insight - Makers of Q-file IT Reference Guides
>http://www.q-file.com
>
>
>Tapan Trivedi <tapan.trivedi_at_abbnm.com> wrote in message
>news:382A36DE.5D1083E8_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:21:52 CST
