This content has been marked as final. Show 3 replies
8 instances ? If it is a production server it is not really a good situation and even if it is often difficult you could think of consolidating the databases.
Read that from Tom Kyte : http://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:4347545437371
You can increase the SGA as suggested but perhaps things will go worse for the other instances since you don't know anything about the situation. Perhaps this server is swapping for example... Did your SA indicate you how much memory you can allocate to Oracle ?
Do you have a trace etc. to know which statement causes the problem ?