Re: SHM

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, May 14, 2003 11:41 AM

> I didn't see the original post, so I'll reply to a reply. You need to
> increas SHMMAX.
> To do that you don't need to relink your kernel. You don't even need to
> reboot
> your machine. Just do following command as root:
>
> echo "<desired maximum size of a segment>">/proc/sys/kernel/shmmax
>
> to set the desired max. size. BTW, I'm also running Red Hat, but 8.0,
> with kernel 2.4.20 and oracle 9.2.0.3. Works like a charm:
>
>
> SQL*Plus: Release 9.2.0.3.0 - Production on Tue May 13 23:36:01 2003
>
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>
> SQL> Connected to an idle instance.
> SQL> ORACLE instance started.
>
> Total System Global Area 235999908 bytes
> Fixed Size 451236 bytes
> Variable Size 201326592 bytes
> Database Buffers 33554432 bytes
> Redo Buffers 667648 bytes
> Database mounted.
> Database opened.
> SQL> Disconnected from Oracle9i Enterprise Edition Release 9.2.0.3.0 -
> Production
> With the Partitioning option
> JServer Release 9.2.0.3.0 - Production
>
> Database "o9i" warm started.
>
>

Mladen,

Wow...thanks Mladen, that's cool!
I'm still worry that i have to recompile the kernel, since i've never done it successfully, bad luck hah... :(

Oh....the max size of segment i need to echo is in hexa or decimal? What entry should i make in sysctl.conf to make it change the setting automatically?
"kernel.shmmax = 20000000"?
and again....hexa?

Shuan.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: =?big5?B?c2h1YW4udGF5XChQQ0m+R7hSs9RcKQ==?=
  INET: shuan.tay_at_pci.co.id

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).