First page Back Continue Last page Graphics

Continuation of Notes


Notes:

The supplied script v$backup_async_io.sql revealed the statistics for the backup using asynchronous I/O:
-- Display performance data for a channel:
select to_char(close_time, 'mm/dd hh:mi') as time, type,
elapsed_time as et, effective_bytes_per_second as eb
from v$backup_async_io
where close_time > sysdate - (1/24 / 4)
and type = 'AGGREGATE';