OraFAQ Forum: Server Administration » ORA-04034: unable to shrink pool to specified size

Home » RDBMS Server » Server Administration » ORA-04034: unable to shrink pool to specified size (Oracle 10.1.0.2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-04034: unable to shrink pool to specified size [message #338238]

Mon, 04 August 2008 05:17

ankush_chawla
Messages: 136
Registered: November 2006

Senior Member

hello

i was trying to reduce the shared pool size but it gave me the error
Currently the size is 120m
SQL>Alter system set shared_pool_size=80m
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-04034: unable to shrink pool to specified size

Kindly help

Regards
ankush

Report message to a moderator

Re: ORA-04034: unable to shrink pool to specified size [message #338239 is a reply to message #338238]

Mon, 04 August 2008 05:19

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

SQL> !oerr ora 4034
04034, 00000, "unable to shrink pool to specified size"
// *Cause:  The pool could not shrink to the specified size as it could not
//          free memory.
// *Action: Specify a larger value to which to shrink the pool to.

Report message to a moderator