Oracle9i Database Reference
Release 1 (9.0.1)

Part Number A90190-02
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

Dynamic Performance (V$) Views, 18 of 211


V$BACKUP_SYNC_IO

This view displays performance information about ongoing and recently completed RMAN backups and restores. For each backup, it contains one row for each input datafile, one row for the aggregate total performance of all datafiles, and one row for the output backup piece. This data is not stored persistently, and is not preserved when the instance is re-started.

See Also:

Oracle9i Database Performance Guide and Reference for information on how to use this table to tune backup performance 

Column  Datatype  Description 

SID 

NUMBER 

The Oracle SID of the session doing the backup or restore 

SERIAL 

NUMBER 

The use count for the SID doing the backup or restore 

USE_COUNT 

NUMBER 

A counter that can be used to identify rows from different backup sets 

DEVICE_TYPE 

VARCHAR2(17) 

The device type where the file is located 

TYPE 

VARCHAR2(9) 

INPUT, OUTPUT, or AGGREGATE 

STATUS 

VARCHAR2(11) 

NOT STARTED, IN PROGRESS, or FINISHED 

FILENAME 

VARCHAR2(513) 

The name of the backup file being read or written 

SET_COUNT 

NUMBER 

The set count of the backup set being read or written 

SET_STAMP 

NUMBER 

The set stamp of the backup set being read or written 

BUFFER_SIZE 

NUMBER 

The size of the buffers being used to read/write this file, in bytes 

BUFFER_COUNT 

NUMBER 

The number of buffers being used to read/write this file 

TOTAL_BYTES 

NUMBER 

The total number of bytes that will be read or written for this file, if known. If not known, this column will be null. 

OPEN_TIME 

DATE 

The time this file was opened. If TYPE='AGGREGATE', then this is the time that the first file in the aggregate was opened. 

CLOSE_TIME 

DATE 

The time this file was closed. If TYPE='AGGREGATE', then this is the time that the last file in the aggregate was closed. 

ELAPSED_TIME 

NUMBER 

The time, in 100ths of seconds, that the file was open 

MAXOPENFILES 

NUMBER 

The number of concurrently open DISK files. This value is only present in rows where TYPE='AGGREGATE'. 

BYTES 

NUMBER 

The number of bytes read or written so far 

EFFECTIVE_BYTES_PER_SECOND 

NUMBER 

The I/O rate that was achieved with this device during this backup 

IO_COUNT 

NUMBER 

The number of I/Os that were performed to this file 

IO_TIME_TOTAL 

NUMBER 

The total time, in 100ths of seconds, taken to do I/O for this file 

IO_TIME_MAX 

NUMBER 

The maximum time taken for a single I/O request 

DISCRETE_BYTES_PER_SECOND 

NUMBER 

The average transfer rate for this file 


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback