Re: Kernel Paremeters Tuning
From: jawa <Jim.Wadas_at_motorola.com>
Date: Wed, 10 Nov 1999 15:31:09 -0700
Message-ID: <80crne$n2s$1_at_schbbs.mot.com>
Date: Wed, 10 Nov 1999 15:31:09 -0700
Message-ID: <80crne$n2s$1_at_schbbs.mot.com>
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 Tapan Trivedi wrote in message <382A36CB.CFD022D2_at_abbnm.com>...Received on Wed Nov 10 1999 - 23:31:09 CET
>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
>