Kernel Parameters Tuning 
Author Message
 Kernel Parameters Tuning
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



Wed, 18 Jun 1902 08:00:00 GMT
 Kernel Parameters Tuning

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


Quote:
> 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



Wed, 18 Jun 1902 08:00:00 GMT
 Kernel Parameters Tuning
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


Quote:
>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



>> 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



Wed, 18 Jun 1902 08:00:00 GMT
 Kernel Parameters Tuning
The place to start looking is in the Oracle documentation,
specifically:

    Oracle for UNIX Performance Tuning Tips and
    Oracle for DEC UNIX Performance Tuning Tips.

If DEC UNIX is a "plain vanilla no-frills" UNIX there may not be
a separate publication addressing DEC UNIX.

hth
jerry gitomer

Quote:

>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



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Tuning Kernel Parameters In Linux (Redhat)

2. FW: Tuning Kernel Parameters for Informix

3. server tuning/HPUX kernel parameters?

4. SCO Kernel Parameters and Onconfig parameters

5. Oracle/Linux kernel tuning

6. Questions on kernel tuning on aix 3.2.5 / 4.2 running Oracle Financials-like applications

7. SunOS 4.1.3 Kernel Tuning for Informix 5.0

8. Disabling kaio and kernel tuning

9. Tuning kernel for Pyramid Nile

10. Solaris kernel tuning for Progress V8.2A

11. Size of SGA and kernel parameters


 
Powered by phpBB® Forum Software