Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: RMAN, v$session_longops and Ora-03113
Sorry Tim - I made the mistake of assuming it was common knowledge of how
closely linked RMAN and long ops are:( See my reply to Jared's post for more
precise details but there is no "tenuous association" between the 2 but a
100% reproducable one! It is not RMAN that causes the error (again apologies
if my original post was unclear on that point) but RMAN that suffers once
the of querying v$session_longops results in the ora-03113 error. When you
can no longer query v$session_longops without getting the error RMAN cannot
complete etc.
Hope I've done a better job in explaining myself this time.
T¬
>RMAN posts to V$SESSION_LONGOPS extensively, presumably (but not
>positively)
>using the DBMS_APPLICATION_INFO packaged procedures as anybody can...
>That's the only way the two can be linked. Still unsure about how posting
>to V$SESSION_LONGOPS by RMAN can cause ORA-03113 on subsequent queries by
>other sessions -- as Jared indicates, it sounds rather tenuous to associate
>one to the other. It smacks of the logic that runs "Whatever changed
>recently must be the cause ... somehow or other"...
-- http://www.freelists.org/webpage/oracle-lReceived on Thu May 19 2005 - 08:40:36 CDT
![]() |
![]() |