Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: RMAN, v$session_longops and Ora-03113

Re: RMAN, v$session_longops and Ora-03113

From: Tim Onions <att755_at_hotmail.com>
Date: Thu, 19 May 2005 13:35:19 +0100
Message-ID: <BAY9-F242B0060630F94E956B2F699080@phx.gbl>


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"...



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
Received on Thu May 19 2005 - 08:40:36 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US