Alter Shared pool [message #556354] |
Sat, 02 June 2012 05:34 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/d766d70559a6ba41440cbfb6498b6207?s=64&d=mm&r=g) |
chanchu
Messages: 11 Registered: May 2012
|
Junior Member |
|
|
SQL> show parameter shared_pool;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
shared_pool_reserved_size big integer 6710886
shared_pool_size big integer 152M
SQL> alter system set shared_pool_size=180M;
alter system set shared_pool_size=180M
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-04033: Insufficient memory to grow pool
|
|
|
|
|
|