Home » RDBMS Server » Server Administration » ORA-04034: unable to shrink pool to specified size (Oracle 10.1.0.2)
ORA-04034: unable to shrink pool to specified size [message #338238] Mon, 04 August 2008 05:17 Go to next message
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
Re: ORA-04034: unable to shrink pool to specified size [message #338239 is a reply to message #338238] Mon, 04 August 2008 05:19 Go to previous messageGo to next message
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.

Re: ORA-04034: unable to shrink pool to specified size [message #338244 is a reply to message #338239] Mon, 04 August 2008 05:29 Go to previous messageGo to next message
ankush_chawla
Messages: 136
Registered: November 2006
Senior Member
flushing the shared pool didnt help either.
Morever the size is not being reduced by 1 M either.

Re: ORA-04034: unable to shrink pool to specified size [message #338467 is a reply to message #338244] Tue, 05 August 2008 03:34 Go to previous messageGo to next message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
On which version of oracle you are working?
Re: ORA-04034: unable to shrink pool to specified size [message #338480 is a reply to message #338467] Tue, 05 August 2008 04:00 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is in the title: 10.1.0.2
Regards
Michel

[Updated on: Tue, 05 August 2008 04:00]

Report message to a moderator

Previous Topic: Change the partition type online
Next Topic: Max number of processes ora-00020 message
Goto Forum:
  


Current Time: Sat Dec 10 01:12:43 CST 2016

Total time taken to generate the page: 0.14743 seconds