RMAN, v$session_longops and Ora-03113 2005-05-19 - By Tim Onions
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 (See ora-03113.ora-code.com) 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 (See ORA-03113.ora-code.com) 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!
http://www.msn.co.uk/newsletters
--
http://www.freelists.org/webpage/oracle-l
|
|
