Change SGA size -- two instances on one server.
51182Jan 30 2007 — edited Jan 30 2007My curretn SGA setting is:
ProductionDB
shared pool :80
Buffer Chae:618
Total SGA : 699
SGA Max: 739
I would like to change this to:
shared pool :800
Buffer Chae:1400
Total SGA : 2200
SGA Max: 2256
what isi the best way to do this..
Can you show me the sept by step instruction? Can I use OEM to do this? DO I have to restart the DB ?
Alos, There is another Oracle instance(test DB) with the same SGA setting running on this server.. the total memory size that is allocated to Oracle is 2 GB... DO I have to delete the another instance ( test DB) to be able to increase the size of production SGA