RE: v$backup_sync

From: Marquez, Chris <cmarquez_at_collegeboard.org>
Date: Tue, 18 Oct 2005 12:52:33 -0400
Message-ID: <B30C2483766F9342B6AEF108833CC84E05BD6008@ecogenemld50.Org.Collegeboard.local>

I always thought it was the rate at which Oracle (RMAN) was doing the reading, "PULLING", not the rate if a writing or "PUSHING" to MML-TAPE or DISK? But I guess neither lives in isolation.

???

---V$BACKUP_SYNC_IO;

This view provides information about the current status of active backup to DISK.

USE_COUNT DEVICE_TYPE TYPE STATUS FILENAME TOTAL_BYTES TO_CHAR(OPEN_TIME TO_CHAR(CLOSE_TIM ELAPSED_MIN MAXOPENFILES BYTES EFFECTIVE_BYTES_PER_SECOND IO_COUNT READY
---------- ----------------- --------- ----------- -------------------- ----------- ----------------- ----------------- ----------- ------------ ---------- -------------------------- ---------- ----------

        31 DISK              AGGREGATE UNKNOWN                           2.9150E+10 14-JAN-2002-04:16 14-JAN-2002-06:50      154.15            4 2.9150E+10                    3151737      27804      20563
        31 DISK              INPUT     FINISHED    /dev/rdrd/drd10074    2.0972E+10 14-JAN-2002-04:16 14-JAN-2002-06:50      154.15              2.0972E+10                    2267436      20001      14722
        31 DISK              INPUT     FINISHED    /dev/rdrd/drd10278    4194304000 14-JAN-2002-04:16 14-JAN-2002-05:53  97.5166667              4194304000                     716853       4001       2996
        31 DISK              INPUT     FINISHED    /dev/rdrd/drd10280    2936012800 14-JAN-2002-04:16 14-JAN-2002-05:35  79.6666667              2936012800                     614229       2801       2097
        31 DISK              INPUT     FINISHED    /dev/rdrd/drd10106    1048576000 14-JAN-2002-04:16 14-JAN-2002-04:53  37.7833333              1048576000                     462539       1001        748
        31 SBT_TAPE          OUTPUT    FINISHED    DEV_5kde82tg_1_1.bkp             14-JAN-2002-04:16 14-JAN-2002-06:50      154.25              1.1791E+10                    1273969     179910     127718

Chris Marquez
Oracle DBA

-----Original Message-----

From: oracle-l-bounce_at_freelists.org on behalf of Jos Sent: Tue 10/18/2005 7:57 AM
To: oracle-l_at_freelists.org
Subject: v$backup_sync_io

Hi,
In the v$backup_sync_io view, there is a column call something like effective_bytes_transfer. If I am getting a low value for this column, does it indicates there is an I/O issue to the backup media or could it means RMAN is not reading blocks fast enough for the backup?
Jos

Do you Yahoo!?
Find a local business fast with Yahoo! Local Search http://au.local.yahoo.com
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Tue Oct 18 2005 - 11:56:30 CDT

RE: v$backup_sync_io