--- Dmitry Melekhov <dm@(protected):
> I can't get SGA size more that 1.7Gb on Mandrake
> with 184.108.40.206:
> 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:
: parameter cannot be modified because
> specified value is invalid
: 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?
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.
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger.
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting