Increase SGA size and redo log size in Oracle 10g
Posted on 2011-09-23
I need solution for the below 2 questions
a) I need to increase the SGA size in the database by 1g in Oracle 10.2.0.4 single instance database. Can anyone please tell me the steps to do that.
b) Also, i am getting errors in the alert log saying
Thread 1 cannot allocate new log, sequence 1530
Private strand flush not complete
I am planning to add new redo log groups. What are the steps to do it?