RMAN备份动态性能视图 V$BACKUP_SET_SUMMARY

最新推荐文章于 2021-11-16 16:11:39 发布

WarriorTan

最新推荐文章于 2021-11-16 16:11:39 发布

阅读量1.1k

点赞数

分类专栏： Oracle动态性能视图|备份相关视图

本文链接：https://blog.csdn.net/jiaping0424/article/details/51338755

版权

6 篇文章 0 订阅

订阅专栏

该视图中只有一条记录，统计自所有备份集的数据，此视图不常用。

V$BACKUP_SET_SUMMARY provides summary information for a backup set.

Column	Datatype	Description
`NUM_BACKUPSETS`	`NUMBER`	Total number of backup sets created
`OLDEST_BACKUP_TIME`	`DATE`	Oldest backup start time
`NEWEST_BACKUP_TIME`	`DATE`	Newest backup start time
`OUTPUT_BYTES`	`NUMBER`	Number of output bytes (not including multiple copies)
`ORIGINAL_INPUT_BYTES`	`NUMBER`	Number of input bytes when backup sets were created
`ORIGINAL_INPRATE_BYTES`	`NUMBER`	Average input rate
`OUTPUT_RATE_BYTES`	`NUMBER`	Average output rate
`COMPRESSION_RATIO`	`NUMBER`	The ratio between the total blocks in the datafile and the blocks that RMAN backed up. This is not the the ratio from the `AS COMPRESSED BACKUPSET` clause of the`BACKUP` command.
`ORIGINAL_INPUT_BYTES_DISPLAY`	`VARCHAR2(4000)`	Displayable format for input bytes
`OUTPUT_BYTES_DISPLAY`	`VARCHAR2(4000)`	Displayable format for output bytes
`ORIGINAL_INPRATE_BYTES_DISPLAY`	`VARCHAR2(4000)`	Displayable format for input rate
`OUTPUT_RATE_BYTES_DISPLAY`	`VARCHAR2(4000)`	Displayable format for output rate