Increase SGA size and redo log size in Oracle 10g

Hi,

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?

Thanks
aravind_314Asked:
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
http://download.oracle.com/docs/cd/B10500_01/server.920/a96521/onlineredo.htm
0
 
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.
0
 
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.
0
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.