Весит две сесси rman
первая
SELECT action
FROM gv$session
WHERE sid = :1
AND serial# = :2
AND inst_id = :3
SELECT STATEMENT
3 NESTED LOOPS
1 SYS.X$KSUSE (ind:1) FIXED TABLE [FIXED INDEX]
2 SYS.X$KSLED (ind:2) FIXED TABLE [FIXED INDEX]
и вторая
SELECT round(sum(mbytes_processed)), round(sum(input_bytes)), round(sum(
output_bytes))
FROM v$rman_status
START WITH recid = :b1
AND stamp = :b2
CONNECT BY PRIOR recid = parent_recid
49 SELECT STATEMENT
48 SORT [AGGREGATE]
47 CONNECT BY [WITH FILTERING]
21 HASH JOIN
13 HASH JOIN
5 FILTER
4 HASH JOIN [OUTER]
1 SYS.X$KCCRSR FIXED TABLE [FULL]
3 SYS.GV$RMAN_STATUS_CURRENT VIEW
2 SYS.X$KRBMRST FIXED TABLE [FULL]
12 SYS. VIEW
11 SORT [GROUP BY]
10 HASH JOIN [OUTER]
6 SYS.X$KCCRSR FIXED TABLE [FULL]
9 SYS. VIEW
8 SORT [GROUP BY]
7 SYS.X$KSFQP FIXED TABLE [FULL]
20 SYS. VIEW
19 SORT [UNIQUE]
18 HASH JOIN [OUTER]
14 SYS.X$KCCRSR FIXED TABLE [FULL]
17 SYS. VIEW
16 WINDOW [SORT]
15 SYS.X$KSFQP FIXED TABLE [FULL]
46 HASH JOIN
22 CONNECT BY PUMP
45 FILTER
44 HASH JOIN [RIGHT OUTER]
24 SYS.GV$RMAN_STATUS_CURRENT VIEW
23 SYS.X$KRBMRST FIXED TABLE [FULL]
43 MERGE JOIN [CARTESIAN]
40 MERGE JOIN [CARTESIAN]
31 SYS. VIEW
30 SORT [GROUP BY]
29 HASH JOIN [OUTER]
25 SYS.X$KCCRSR FIXED TABLE [FULL]
28 SYS. VIEW
27 SORT [GROUP BY]
26 SYS.X$KSFQP FIXED TABLE [FULL]
39 BUFFER [SORT]
38 SYS. VIEW
37 SORT [UNIQUE]
36 HASH JOIN [OUTER]
32 SYS.X$KCCRSR FIXED TABLE [FULL]
35 SYS. VIEW
34 WINDOW [SORT]
33 SYS.X$KSFQP FIXED TABLE [FULL]
42 BUFFER [SORT]
41 SYS.X$KCCRSR FIXED TABLE [FULL]