This content has been marked as final. Show 6 replies
Always it is recommended to keep "shmmax" half the size of physical memory.
First you need to increase shmmax and then increase the SGA_MAX_SIZE as per ADDM.
See the below doc for all your answers answers.
Hope this solves your issue.
Click here for solution - [ORA-19755 Error during recovery/DB startup|http://www.oracleracexpert.com/2009/09/ora-19755-could-not-open-change.html]
Click here to learn [Block corruption and recovery|http://www.oracleracexpert.com/2009/08/block-corruption-and-recovery.html]
Click here to learn [Transportable tablespace export and import |http://www.oracleracexpert.com/2009/09/transportable-tablespace-export-and.html]
Edited by: Satishbabu Gunukula on Sep 23, 2009 2:43 PM
user1368801 wrote:Not generally, but there have been reports of certain platform configurations not handling multiple segments correctly. Kind of rare and obscure, go ahead and try it, either it will work or blow up. If it blows up, go back to old setting and ask here again, with error message.
so without increasing the shmmax, if I increase the SGA_MAX_SIZE, will there be any problem ?
Be aware that sometimes the advisors just keep asking for more and more, they're useful, but can be fooled (and sometimes misleading with those % improvement predictions). Making everything worse can happen, but is somewhat unusual if not accompanied by gross obvious problems like swapping.