Alter Shared pool [message #556354] |
Sat, 02 June 2012 05:34 |
|
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
|
|
|
|
|
|