resize redo logs to decrease archivelog generation

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

resize redo logs to decrease archivelog generation

Roshan
Oracle DB 12.1.0.2
AIX

Hello Erman,

trust you are fine.

We have configured CDC on an Oracle server using Striim. Each redo logs are sized 1073741824 bytes. We have 3 redo log groups. I would Like to increase the number of redo logs. What metrics should I consider to know the number of redo logs to add.
 
The loginer read rate was discussed below.
http://erman-arslan-s-oracle-forum.124.s1.nabble.com/logminer-read-rate-tp9605.html

Thanks,

Roshan
Reply | Threaded
Open this post in threaded view
|

Re: resize redo logs to decrease archivelog generation

ErmanArslansOracleBlog
Administrator
Thanks Roshan I m fine.
You need to consider the log switch frequency and the size of redo that you expect -- redo generated by your future DML operations.
You should be able to support the DML generation with your redo log size and count.. You shouldn't be blocking the database due to a redo member being active or current.. You need to have at least for redo available for us even in the case of a huge DML operations.. So consider sizing your redologs and adding more redologs accordingly. This is not related with striim or CDC.. Striim or CDC just reads the redo which is already placed in redologs or archivelog.. What you are asking is the redo size and count and it is related with your database config.