tag:blogger.com,1999:blog-2754422473924744459.post8734091093047143785..comments2023-06-25T15:23:10.819+05:30Comments on Oracle FMW Articles: OID Performance TuningGanesh Kamblehttp://www.blogger.com/profile/02592846460289933723noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-2754422473924744459.post-54399918520172293832013-05-27T08:41:58.651+05:302013-05-27T08:41:58.651+05:30Hi,
You can find the solution at :
http://www.dbm...Hi,<br /><br />You can find the solution at :<br />http://www.dbmotive.com/ora-00851-sga_max_size-d-cannot-be-set-to-more-than-memory_target-d/Anonymoushttps://www.blogger.com/profile/09781890334908541166noreply@blogger.comtag:blogger.com,1999:blog-2754422473924744459.post-56495381581450071572013-05-24T11:19:35.556+05:302013-05-24T11:19:35.556+05:30Hi,
as we need to set 60% of RAM, but what will be...Hi,<br />as we need to set 60% of RAM, but what will be the RAM size...are we taking the Box RAM size which is in my case 5GB..if yes then after setting the 60% of 5GB of sga_target and sga_max_size = 60% * 5120M = 3072M I am not able to restart the DB. getting the error as:<br /><br />SQL> startup;<br />ORA-00844: Parameter not taking MEMORY_TARGET into account<br />ORA-00851: SGA_MAX_SIZE 3221225472 cannot be set to more than MEMORY_TARGET 1275068416.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2754422473924744459.post-7894056573010397772012-10-04T10:10:26.125+05:302012-10-04T10:10:26.125+05:30Thanks!!! this is just wat i was looking forThanks!!! this is just wat i was looking forAnonymousnoreply@blogger.com