Databases Reference
In-Depth Information
where (sid, serial) not in (select sid, serial from pre_backup_async_io));
--
create table backup_sync_io
as (select * from v$backup_sync_io
where (sid, serial) not in (select sid, serial from pre_backup_sync_io));
--
create table post_cmd_wait_time
as select sum (time_waited_micro/1000000) time_waited_secs from v$system_event
where event like '%sbt%';
--
variable sbttime_in_secs number;
begin
select post.time_waited_secs - nvl(pre.time_waited_secs, 0)
into :sbttime_in_secs from pre_cmd_wait_time pre, post_cmd_wait_time post;
end;
/
variable cmdtime_in_secs number;
begin
select (end_time - start_time)*24*60*60 into :cmdtime_in_secs
from cmd_start_time, cmd_end_time;
end;
/
variable total_input_bytes number;
begin
select sum(bytes) into :total_input_bytes
from (select sum(bytes) bytes
from backup_async_io where type='INPUT'
union
select sum(bytes) bytes
from backup_sync_io where type='INPUT');
end;
/
variable total_output_bytes number;
begin
select sum(bytes)
into :total_output_bytes
from (select sum(bytes) bytes
from backup_async_io where type='OUTPUT'
union
select sum(bytes) bytes
from backup_sync_io where type='OUTPUT');
end;
/
variable non_sbttime_in_secs number;
begin
:non_sbttime_in_secs := :cmdtime_in_secs - :sbttime_in_secs;
end;
/
-- STATISTICS SECTION
-- Relevant statistics that are useful to identify
-- RMAN performance problems are displayed below.
-- SBTTIME_IN_SECS is amount of time that was spent in SBT library
