AMD64, SGA, offtopic 2004-06-04 - By Magni Fabrizio
Hi Dmitry,
have a look at this:
http://rootshell.be/~yong321/computer/sgabegbug.txt
I think this is what you are looking for.
Have fun with 64 bit...
Fabrizio
> -- --Original Message-- --
> From: Dmitry Melekhov [mailto:dm@(protected)]
> Sent: 04 June, 2004 14:07
> To: Sun_shine_man
> Cc: suse-oracle@(protected)
> Subject: Re: [suse-oracle] AMD64, SGA, offtopic
>
>
> Zolotko A. Sergey wrote:
>
> >Hi, Dmitry.
> >
> >You wrote 4.06.2004, 14:34:02:
> >
> >DM> Hello!
> >
> >DM> I can't get SGA size more that 1.7Gb on Mandrake 9.2/2.6.3
> >DM> with 9.2.0.4:
> >
> >SQL>> startup
> >DM> ORACLE instance started.
> >
> >DM> Total System Global Area 1796705872 bytes
> >DM> Fixed Size 745040 bytes
> >DM> Variable Size 1761607680 bytes
> >DM> Database Buffers 33554432 bytes
> >DM> Redo Buffers 798720 bytes
> >DM> Database mounted.
> >DM> Database opened.
> >SQL>> alter system set shared_pool_size=1796705872;
> >DM> alter system set shared_pool_size=1796705872
> >DM> *
> >DM> ERROR at line 1:
> >DM> ORA-02097 (See ORA-02097.ora-code.com): parameter cannot be modified because
> specified value is invalid
> >DM> ORA-04033 (See ORA-04033.ora-code.com): Insufficient memory to grow pool
> >
> >
> >DM> shmmax value is very high.
> >
> >DM> May be this is Mandrake or 2.6.3 kernel? :-)
> >
> >DM> Or, may be I need to do something special? ;-)
> >
> >DM> any ideas?
> >
> >Check do you set SGA_MAX_SIZE.
> >
>
> Yes, it is high enough.
> btw, when I try to start Oracle with lage shared pool I get:
>
> SQL> startup
> ORA-27123 (See ORA-27123.ora-code.com): unable to attach to shared memory segment
> Linux-x86_64 Error: 22: Invalid argument
> Additional information: 1
> Additional information: 15269948
>
> >But size shared_pool_size=1796705872 must be equal a multiple of
> >granule size (16M in your case).
> >
> >
>
> Thank you, but this doesn't help :-(
>
>
> I guess that my problem is in my kernel (i.e. 2.6.3 from kernel.org,
> well, with some patches), but don't shure.
> Looks like I have to ask about Suse's kernel ( I mean it's difference
> from kernel.org) in amd64 list.
>
> >
> >
> >
> >
>
>
>
> --
> To unsubscribe, email: suse-oracle-unsubscribe@(protected)
> For additional commands, email: suse-oracle-help@(protected)
> Please see http://www.suse.com/oracle/ before posting
>
|
|
