- Your SGA_MAX_SIZE is set to 1796705872 bytes.
- You cannot allocate dynamic SGA components where the combined total
is larger than that value.
- SHARED_POOL_SIZE is just one of those components. And it seems
you're trying to set it to max out your 1796705872 bytes. What about
your other components?
dm_at_belkam.com (Dmitry Melekhov) wrote in message news:<48f1f058.0406040229.549a78db_at_posting.google.com>...
> 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: parameter cannot be modified because specified value is invalid
> ORA-04033: Insufficient memory to grow pool
>
>
> shmmax value is very high
>
> any ideas?
Received on Fri Jun 04 2004 - 11:36:29 CDT
