Created
February 3, 2011 17:54
-
-
Save neilkod/809864 to your computer and use it in GitHub Desktop.
statistics on most recent rman backups.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
column time_taken_display format a12 | |
column input_per_sec format a13 | |
column output_per_sec format a13 | |
column input_gb format 9999 | |
column output_gb format 9999 | |
column status format a10 | |
set lines 300 pages 300 | |
select start_time | |
, end_time | |
, input_bytes_per_sec_display input_per_sec | |
, output_bytes_per_sec_display output_per_sec | |
, status | |
, time_taken_display | |
, input_type | |
, input_bytes/1024/1024/1024 input_gb | |
, output_bytes/1024/1024/1024 output_gb | |
, optimized | |
, compression_ratio | |
from v$rman_backup_job_details | |
order by start_time; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment