AMD64, SGA, offtopic 2004-06-04 - By Paul Drake
--- Dmitry Melekhov <dm@(protected)> wrote:
> Hello!
>
> I can't get SGA size more that 1.7Gb on Mandrake
> 9.2/2.6.3
> with 9.2.0.4:
>
> SQL> startup
> ORACLE instance started.
>
> Total System Global Area 1796705872 bytes
> Fixed Size 745040 bytes
> Variable Size 1761607680 bytes
> Database Buffers 33554432 bytes
> Redo Buffers 798720 bytes
> Database mounted.
> Database opened.
> SQL> alter system set shared_pool_size=1796705872;
> alter system set shared_pool_size=1796705872
> *
> ERROR at line 1:
> ORA-02097 (See ORA-02097.ora-code.com): parameter cannot be modified because
> specified value is invalid
> ORA-04033 (See ORA-04033.ora-code.com): Insufficient memory to grow pool
>
>
> shmmax value is very high.
>
> May be this is Mandrake or 2.6.3 kernel? :-)
>
> Or, may be I need to do something special? ;-)
>
> any ideas?
>
yes.
Q: What is the simplest way to do something?
A: Don't do it.
why would you want an SGA of 1.7 GB?
I can understand wanting to have a buffer cache of 1
GB or larger. But a shared pool above 320 MB? no way.
Q: what problem are you attempting to solve by running
a 1.7 GB SGA?
I would seriously examine your memory requirements.
Pd
__ ____ ____ ____ ____ ____ ______
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/
--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting
|
|
