REPOST: Re: Relocating the SGA

What are the settings for shared memory in the O/S?

Daniel Morgan

Slawomir Cichy wrote:

> Hi,
>
> I have two machines. I named them M1 and M2.
> ------------------------------------------------
> M1:
> OS: Linux 2.2.18 #1 SMP
> DB: Oracle EE 8.1.6.2
> RAM: 1G
> ------------------------------------------------
> M2:
> OS: Linux 2.2.18 #14 SMP
> DB: Oracle EE 8.1.6.2
> RAM: 2G
> ------------------------------------------------
>
> I have problem with the alocation of shared memory on M2. I can't alocate
> more then 700 M (?) of shared memory. Now, I'm having following parameters
> in init.ora
>
> shared_pool_size 134217728
> db_block_buffers 32768
> db_block_size 16384
> sort_area_size 20971520
>
> and it is working OK, but not perfectly:
>
> (/d0/oracle/admin/ANDRO)> free
> total used free shared buffers cached
> Mem: 2009368 1979432 29936 2195168 151864 948020
> -/+ buffers/cache: 879548 1129820
> Swap: 1052248 1092 1051156
>
> It looks like I use only ~50% memory. I increase db_block_buffers in init.ora
>
> db_block_buffers 39168
> ^^^^^
> and I receive the following error while instance is starting:
>
> SVRMGR> connect internal
> Connected.
> SVRMGR> startup
> ORA-27123: unable to attach to shared memory segment
> Linux Error: 22: Invalid argument
> SVRMGR>
> (?????!)
>
> I done it on M1 and first configuration is evidently OK, and second... too
> (?!)
>
> SVRMGR> connect internal
> Connected.
> SVRMGR> startup
> ORACLE instance started.
> Total System Global Area 817487856 bytes
> Fixed Size 69616 bytes
> Variable Size 144224256 bytes
> Database Buffers 641728512 bytes
> Redo Buffers 31465472 bytes
>
> (?!)
>
> Why? Do You have this problem on Linux?
>
> Configuration of the kernels on M1 and M2, with regard for shared memory,
> are identical. Command "ipcs -l" returned just the same values of limits.
> Command "tstshm" returned following information:
> -------------------------------------------------
> M1:
> Number of segments gotten by shmget() = 50
> Number of segments attached by shmat() = 50
> Segments attach at higher addresses
> Default shared memory address = 0x406b0000
> Lowest shared memory address = 0x406b0000
> Highest shared memory address = 0x46ab0000
> Total shared memory range = 106954752
> Total shared memory attached = 104857600
> Largest single segment size = 2097152
> Segment boundaries (SHMLBA) = 4096 (0x1000)
> -------------------------------------------------
> M2:
> Number of segments gotten by shmget() = 50
> Number of segments attached by shmat() = 50
> Segments attach at higher addresses
> Default shared memory address = 0x2b15d000
> Lowest shared memory address = 0x2b15d000
> Highest shared memory address = 0x3155d000
> Total shared memory range = 106954752
> Total shared memory attached = 104857600
> Largest single segment size = 2097152
> Segment boundaries (SHMLBA) = 4096 (0x1000)
> -------------------------------------------------
>
> Please, help me :)
>
> Thanks in advance.
> Slawas

• WAS CANCELLED BY =======: From: "Daniel A. Morgan" <damorgan_at_exesolutions.com> Control: cancel <3C512E55.CC4374ED_at_exesolutions.com> Subject: cmsg cancel <3C512E55.CC4374ED_at_exesolutions.com> Date: Mon, 28 Jan 2002 00:33:41 GMT Message-ID: <cancel.3C512E55.CC4374ED_at_exesolutions.com> X-No-Archive: yes Newsgroups: microsoft.test,alt.flame.niggers,comp.databases.oracle.server NNTP-Posting-Host: w088.z064003087.lax-ca.dsl.cnc.net 64.3.87.88 Lines: 1 Path: news.uni-stuttgart.de!blackbush.xlink.net!blackbush.de.kpnqwest.net!newsfeed01.sul.t-online.de!t-online.de!fr.clara.net!heighliner.fr.clara.net!opentransit.net!news.stealth.net!msrtrans1!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp04!u&n&a&c&anceller Xref: news.uni-stuttgart.de control:40722114

This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers. Received on Fri Jan 25 2002 - 04:07:17 CST