total size of transfered archive logs is huge, why?
hi,
it s oracle 11g r2 rac,
my database size is 400gb, but transfered total log size at nights for 5 hours (00:00 - 05:30) 23gb,,, dml load is very low on these hours,,, and i cant understand reason of this huge size for 5 hours,,,
i checked archivelog size on standby side,
SELECT round(sum((blocksblock_size)/1024/1024)) filesize FROM gV$ARCHIVED_LOG WHERE first_time between to_date('05.10.2011 *00:00:11*','DD.MM.YYYY HH24:MI:SS') and to_date('05.10.2011 *05:30:11*','DD.MM.YYYY HH24:MI:SS') ORDER BY SEQUENCE#;*
result is total 23 528 mb, i tried to take offline some delete jobs and checked it at night, transaction count is very low at nights... but result did not changed. i think it s not normal,,,
inst_id recid stamp name dest_id thread# sequence# resetlogs_change# resetlogs_time resetlogs_id first_change# first_time next_change# next_time blocks block_size creator registrar standby_dest archived applied deleted status completion_time dictionary_begin dictionary_end end_of_redo backup_count archival_thread# activation# is_recovery_dest_file compressed fal end_of_redo_type backed_by_vss
1 70500 763690298 1 2 141367 945184 25.01.2011 16:06:31 741369991 65286644046 05.10.2011 00:01:14 65286801081 05.10.2011 00:08:11 152512 512 ARCH RFS NO YES YES YES D 05.10.2011 00:11:38 NO NO NO 0 2 3374609413 YES NO NO NO
2 70500 763690298 1 2 141367 945184 25.01.2011 16:06:31 741369991 65286644046 05.10.2011 00:01:14 65286801081 05.10.2011 00:08:11 152512 512 ARCH RFS NO YES YES YES D 05.10.2011 00:11:38 NO NO NO 0 2 3374609413 YES NO NO NO
2 70503 763691701 1 2 141368 945184 25.01.2011 16:06:31 741369991 65286801081 05.10.2011 00:08:11 65287208248 05.10.2011 00:31:33 157416 512 ARCH RFS NO YES YES YES D 05.10.2011 00:35:01 NO NO NO 0 2 3374609413 YES NO NO NO
1 70503 763691701 1 2 141368 945184 25.01.2011 16:06:31 741369991 65286801081 05.10.2011 00:08:11 65287208248 05.10.2011 00:31:33 157416 512 ARCH RFS NO YES YES YES D 05.10.2011 00:35:01 NO NO NO 0 2 3374609413 YES NO NO NO
....
questions)
*==*
*1)configuration parameters set for compressed data transfer, redo log size is 100mb.. why transfered data files are so huge? what is the content of transfered archive logs?*
how can decrease transfer rate?
2) when i run the same query on primary side;
SELECT round(sum((blocksblock_size)/1024/1024)) filesize FROM gV$ARCHIVED_LOG WHERE first_time between to_date('05.10.2011 00:00:11','DD.MM.YYYY HH24:MI:SS') and to_date('05.10.2011 05:30:11','DD.MM.YYYY HH24:MI:SS') ORDER BY SEQUENCE#;*
sum of total size result is different than standby side, why?