Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 827
  • Last Modified:

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
0
aravind_314
Asked:
aravind_314
  • 2
2 Solutions
 
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
 
Devinder Singh VirdiLead 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
 
schwertnerCommented:
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

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now