_shared_pool_reserved_min_alloc must be between 4000 and 0 in oracle 10G

  • From: "John Dunn" <jdunn@xxxxxxxxx>
  • To: <Oracle-L@xxxxxxxxxxxxx>
  • Date: Mon, 24 Jan 2005 11:51:22 -0000

I am attempting to use automatic shared memory management in oracle 10G, but
having set the sga_target value and attempted to bounce the database I get
the error

ORA-00093: _shared_pool_reserved_min_alloc must be between 4000 and 0

 when I try to startup

If I try to set this value, it then says the parameter is obsolete!.

Anyone know how to get around this?

John



--
//www.freelists.org/webpage/oracle-l

Other related posts: