set linesize 200 heading off
set heading on pagesize 200
column status format a10
column COMMAND_ID for a12
column time_taken_display format a10;
column input_bytes_display format a12;
column output_bytes_display format a12;
column output_bytes_per_sec_display format a10;
column ses_key format 9999999
column ses_recid format 9999999
column device_type format a10
column OutBytesPerSec for a13
SELECT b.session_key ses_key,
b.session_recid ses_recid,
b.session_stamp,
b.command_id,
b.input_type,
b.status,
to_char(b.start_time,'DD-MM-YY HH24:MI') "Start Time",
b.time_taken_display,
b.output_device_type device_type,
b.input_bytes_display,
b.output_bytes_display,
b.output_bytes_per_sec_display "OutBytesPerSec"
FROM v$rman_backup_job_details b
WHERE b.start_time > (SYSDATE - &)
ORDER BY b.start_time desc;
Did this post help you in any way can you please leave a comment? This will motivate me writing more posts.
Monday, March 28, 2011
Subscribe to:
Post Comments (Atom)
Hi Arjan,
ReplyDeleteGood one. I too found this query useful.Using this can we find the size of the database when the rman command is backup database plus archive log?
Thank you,
Vijay
Hi Arjan,
ReplyDeleteI use following select to find the size of backups by Tag:
~~~
select TAG,sum(BYTES/1024/1024) from V$BACKUP_PIECE_DETAILS group by tag order by 2
~~~
Eugene
Wonderful script;Thank you sooooooooo much.Appreciate your rimely help.
ReplyDeleteGood one.
ReplyDeleteThank U........
Oracle Applications
Thank you, Helped me a lot
ReplyDeletenice post.
ReplyDeleteplease keep up the helping work.
could you please explain difference between input byte and output byte ?
ReplyDeleteInput Byte: Sum of sizes of all the DB files.
ReplyDeleteOutput Byte: Sum of the size of the RMAN backup.
It really appreciate you. This query help me a lot.
ReplyDeleteHI ,
ReplyDeleteYour command shows the size , do you have anything for size time and type all 3
파라오카지노 | 카지노사이트 쿠폰 | 바카라사이트 - 더킹오브딜러
ReplyDelete188bet / 188ベットの登録方法、使い方、入出金方法 - カジノ日本
ReplyDelete