Home » RDBMS Server » Performance Tuning » MEMORY_TARGET error (Oracle 11.2.0.1.0, Oracle Enterprise Linux -5)
MEMORY_TARGET error [message #597396] Fri, 04 October 2013 06:45 Go to next message
8939513598$
Messages: 103
Registered: July 2013
Location: chennai
Senior Member
Hi Michel, whether the parameter "MEMORY_TARGET" obsolete in 11.2.0.1.0 ?, iam forwarding the output for your reference,

SQL> alter system set MEMORY_TARGET=10000M scope=spfile;

System altered.

SQL> startup force;
ORA-00845: MEMORY_TARGET not supported on this system
SQL>


what would be reason ?
Re: MEMORY_TARGET error [message #597397 is a reply to message #597396] Fri, 04 October 2013 06:50 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
I hope Michel does mind me taking over your personal request for consultancy services.

Your problem is that you have not configured shared memory correctly at the operating system level. For instance, if you are are using huge pages, AMM is not possible. Otherwise, it could be that you have not configured adequate shared memory segments
icon11.gif  Re: MEMORY_TARGET error [message #597427 is a reply to message #597396] Fri, 04 October 2013 11:02 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Michel Cadot wrote on Fri, 04 October 2013 18:01 at http://www.orafaq.com/forum/mv/msg/189618/597426/#msg_597426

Quote:
Whether the parameter "MEMORY_TARGET" obsolete in 11.2.0.1.0 ?


SQL> select * from V$OBSOLETE_PARAMETER where upper(name)='MEMORY_TARGET';

no rows selected


No.
This can also be checked against the documentation.

ORA-00845: MEMORY_TARGET not supported on this system
 *Cause: The MEMORY_TARGET parameter was not supported on this operating system 
         or /dev/shm was not sized correctly on Linux.
 *Action: Refer to documentation for a list of supported operating systems. 
          Or, size /dev/shm to be at least the SGA_MAX_SIZE on each Oracle instance 
          running on the system.

This can also be checked against the documentation.



Previous Topic: How to configure SGA_MAX_SIZE parameter
Next Topic: about increasing performance speed of slow running package
Goto Forum:
  


Current Time: Fri Mar 29 09:27:36 CDT 2024