The problem is if you unset or set to zero memory_max_target, you get ORA-00849 From: Don Seiler [mailto:don@xxxxxxxxx] Sent: Monday, October 11, 2010 2:46 PM To: s.cislaghi@xxxxxxxxx Cc: Crisler, Jon; oracle-l@xxxxxxxxxxxxx Subject: Re: 11g RedHat 5 and Hugepages? anybody successful ? You can NOT use memory_target or memory_max_target with HugePages. That's a non-starter. Don. On Mon, Oct 11, 2010 at 1:17 PM, Stefano Cislaghi <s.cislaghi@xxxxxxxxx> wrote: Hi, two possibile solution: 1. Open SQLPlus and even with instance in idle execute: create pfile='/tmp/pfilename' from spfile='+ASM/path/to/spfile'; Modify the pfile and then following the same procedure create a new spfile from memory 2. Create a standard pfile, startup nomount your instance and do the step 1 3. With asmcmd you may copy the spfile from ASM to disk, using strings command convert it in plain text and then use if as a pfile BTW, I always avoid to have the spfile in ASM for this and many other similar reasons. Ste -- http://www.stefanocislaghi.eu -- Don Seiler http://seilerwerks.wordpress.com ultimate: http://www.mufc.us