Hello,
We are trying to restore a database, but it very slow.
The sessions are active but only one channel is working (sofar > 0). The others sessions are active but the sofar is ZERO:
SQL> SELECT sl.sid, sl.serial#, s.username, sl.context, sl.sofar, sl.totalwork, round(sl.sofar/sl.totalwork*100,2) "% Complete", s.resource_consumer_group rsrc_grp,
2 s.event, s.status, sl.time_remaining/60 remaining_minutes
3 FROM v$session_longops sl, v$session s
WHERE sl.sid = s.sid
AND sl.serial# = s.serial#
4 5 6 AND sl.opname LIKE 'RMAN:%'
7 AND sl.opname NOT LIKE 'RMAN: aggregate%'
8 AND sl.sofar <> sl.totalwork
9 AND sl.totalwork != 0;
SID SERIAL# USERNAME CONTEXT SOFAR TOTALWORK % Complete RSRC_GRP EVENT STATUS REMAINING_MINUTES
---------- ---------- ---------- ---------- ---------- ---------- ---------- ------------ ---------------------------------- -------- -----------------
5 7 SYS 1 0 793600 0 RMAN backup & recovery I/O ACTIVE
6 7 SYS 1 2216447 22113792 10,02 RMAN backup & recovery I/O ACTIVE 3094,26667
1435 21 SYS 1 0 1310720 0 RMAN backup & recovery I/O ACTIVE
1436 143 SYS 1 0 1159424 0 RMAN backup & recovery I/O ACTIVE
2867 15 SYS 1 0 1572864 0 RMAN backup & recovery I/O ACTIVE
2868 43 SYS 1 0 1326208 0 RMAN backup & recovery I/O ACTIVE
4299 7 SYS 1 0 131072 0 RMAN backup & recovery I/O ACTIVE
4300 7 SYS 1 0 4849664 0 RMAN backup & recovery I/O ACTIVE
How about that behavior?
What else do we need to provide performance?
The Oracle is Enterprise Edition and the release is 11.2.0.4.
SO: Red Hat 6.
thank you!