Increase SGA size and redo log size in Oracle 10g


I need solution for the below 2 questions

a) I need to increase the SGA size in the database by 1g in Oracle 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?

Who is Participating?
Devinder Singh VirdiConnect With a Mentor Lead Oracle DBA TeamCommented:
For first, you need to restart database. Also consider db_cache_size and shared_pool_reserved_size.

To add new redo log group use alter database add log.... command
Devinder Singh VirdiLead Oracle DBA TeamCommented:
Consider two parameters sga_max_size and sga_target for SGA

For second, check if you have disk space available.
schwertnerConnect With a Mentor Commented:
The error:
"Private strand flush not complete" is a message that shows internal Oracle activities and has no influence on the Oracle functionality. There are some inputs about this in the net. So you can ignore this message.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.