RE: v$backup_sync_io
- From: "Marquez, Chris" <cmarquez@xxxxxxxxxxxxxxxx>
- To: <jos1992831@xxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 18 Oct 2005 12:52:33 -0400
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@xxxxxxxxxxxxx on behalf of Jos
Sent: Tue 10/18/2005 7:57 AM
To: oracle-l@xxxxxxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
