From oracle-l-bounce@freelists.org Tue Oct 18 11:56:30 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j9IGuUiS021052 for ; Tue, 18 Oct 2005 11:56:30 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j9IGuSvX021041 for ; Tue, 18 Oct 2005 11:56:28 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E50212069CE; Tue, 18 Oct 2005 11:56:23 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 05823-10; Tue, 18 Oct 2005 11:56:23 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4649E206CBD; Tue, 18 Oct 2005 11:56:23 -0500 (EST) X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C5D404.937AD52C" Subject: RE: v$backup_sync_io Date: Tue, 18 Oct 2005 12:52:33 -0400 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: v$backup_sync_io Thread-Index: AcXT2zE9KxvAs5dVSH6ya9ZT3JxDiQAKSRxY References: <20051018115727.89921.qmail@web53204.mail.yahoo.com> From: "Marquez, Chris" To: , X-archive-position: 27142 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: cmarquez@collegeboard.org Precedence: normal Reply-To: cmarquez@collegeboard.org X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Level: X-Spam-Status: No, hits=-2.8 required=5.0 tests=ADDR_NUMS_AT_BIGSITE,AWL, BAYES_00,HTML_MESSAGE,UPPERCASE_25_50 autolearn=no version=2.63 ------_=_NextPart_001_01C5D404.937AD52C Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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@freelists.org on behalf of Jos Sent: Tue 10/18/2005 7:57 AM To: oracle-l@freelists.org Subject: v$backup_sync_io =20 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 =09 ____________________________________________________=20 Do you Yahoo!?=20 Find a local business fast with Yahoo! Local Search=20 http://au.local.yahoo.com -- http://www.freelists.org/webpage/oracle-l ------_=_NextPart_001_01C5D404.937AD52C Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: v$backup_sync_io

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           &nb= sp;  AGGREGATE = UNKNOWN           =             &= nbsp;   2.9150E+10 14-JAN-2002-04:16 = 14-JAN-2002-06:50      = 154.15            = 4 = 2.9150E+10          &nb= sp;         = 3151737      = 27804      20563
        31 = DISK           &nb= sp;  INPUT     FINISHED    = /dev/rdrd/drd10074    2.0972E+10 14-JAN-2002-04:16 = 14-JAN-2002-06:50      = 154.15           &= nbsp;  = 2.0972E+10          &nb= sp;         = 2267436      = 20001      14722
        31 = DISK           &nb= sp;  INPUT     FINISHED    = /dev/rdrd/drd10278    4194304000 14-JAN-2002-04:16 = 14-JAN-2002-05:53  = 97.5166667          &nb= sp;   = 4194304000          &nb= sp;          = 716853       = 4001       2996
        31 = DISK           &nb= sp;  INPUT     FINISHED    = /dev/rdrd/drd10280    2936012800 14-JAN-2002-04:16 = 14-JAN-2002-05:35  = 79.6666667          &nb= sp;   = 2936012800          &nb= sp;          = 614229       = 2801       2097
        31 = DISK           &nb= sp;  INPUT     FINISHED    = /dev/rdrd/drd10106    1048576000 14-JAN-2002-04:16 = 14-JAN-2002-04:53  = 37.7833333          &nb= sp;   = 1048576000          &nb= sp;          = 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           &= nbsp;  = 1.1791E+10          &nb= sp;         = 1273969     179910     = 127718



Chris Marquez
Oracle DBA

-----Original Message-----
From: oracle-l-bounce@freelists.org on behalf of Jos
Sent: Tue 10/18/2005 7:57 AM
To: oracle-l@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.o= rg/webpage/oracle-l

------_=_NextPart_001_01C5D404.937AD52C-- -- http://www.freelists.org/webpage/oracle-l