Re: RMAN Performance Maladies

  • From: "cnewtonne@xxxxxxxxx" <cnewtonne@xxxxxxxxx>
  • To: ganstadba@xxxxxxxxxxx
  • Date: Tue, 13 Feb 2007 11:57:11 -0500

Mike,
I will be interested if you can provide us with this info please ...
- effective bytes per second from v$backup_async_io for sbt_tape and type of D or L.
- Your RMAN configuration and script.
- Output of code below to show your transfer rates from RMAN. Show us the mb_sec column please.

select bs.completion_time,bs.set_stamp,bs.set_count,bs.backup_type,bs.incremental_level,bs.elapsed_seconds,round((sum(bd.blocks*bd.block_size)/1048576)/bs.elapsed_seconds,2) mb_sec,count(bd.file#),bd.pieces ,round(sum((bd.datafile_blocks*bd.block_size))/1048576,2) db_size_mb,round(sum((bd.blocks*bd.block_size))/1048576,2) Rman_size_mb
from
rc_backup_set bs,
rc_backup_datafile bd
where
bs.set_stamp = bd.set_stamp
and bs.set_count = bd.set_count
----------------------------------------
and bs.db_id=4269907151
----------------------------------------
group by bs.completion_time,bs.set_stamp,bs.set_count,bd.pieces,bs.elapsed_seconds,bs.backup_type,bs.incremental_level
ORDER By bs.completion_time ;
--
//www.freelists.org/webpage/oracle-l


Other related posts: