TA的每日心情 | 开心 2023-8-9 11:05 |
---|
|
- column backup_name format a19 heading 'Backup Name'
- column start_time format a19 heading 'Start Time'
- column elapsed_time format a12 heading 'Elapsed Time'
- column status format a30 heading 'Status'
- column input_type format a30 heading 'Input Type'
- column output_device_type format a11 heading 'Output Type'
- column input_size format a10 heading 'Input Size'
- column output_size format a11 heading 'Output Size'
- column output_rate_per_sec format a13 heading 'Output Rate/s'
- select r.command_id backup_name,
- to_char(r.start_time, 'YYYY-MM-DD HH24:MI:SS') start_time,
- r.time_taken_display elapsed_time,
- status,
- r.input_type input_type,
- r.output_device_type output_device_type,
- r.input_bytes_display input_size,
- r.output_bytes_display output_size,
- r.output_bytes_per_sec_display output_rate_per_sec
- from
- ( select command_id,start_time,time_taken_display,status,input_type,output_device_type,input_bytes_display,output_bytes_display,output_bytes_per_sec_display
- from v$rman_backup_job_details
- order by start_time desc
- ) r
- where sysdate - start_time <= 30;
复制代码
|
|