Skip to content

Instantly share code, notes, and snippets.

@neilkod
Created February 3, 2011 17:54
Show Gist options
  • Save neilkod/809864 to your computer and use it in GitHub Desktop.
Save neilkod/809864 to your computer and use it in GitHub Desktop.
statistics on most recent rman backups.
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