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
Hope I've done a better job in explaining myself this time.
>RMAN posts to V$SESSION_LONGOPS extensively, presumably (but not
>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"...
Be the first to hear what's new at MSN - sign up to our free newsletters!