Oracle FAQ Your Portal to the Oracle Knowledge Grid

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

Re: RMAN, v$session_longops and Ora-03113

From: Jared Still <>
Date: Wed, 18 May 2005 09:35:22 -0700
Message-ID: <>

Hi Tim,
I am confused about the connection between v$session_longops and making a backup.

Your email asserts that the v$session_longops problem prevents backups, but I don't see the connection.


On 5/16/05, Tim Onions <> wrote:
> under Windows 2000 sp4 using Veritas Netbackup (Apologies if
> this
> did get posted already but I received a failure notification so I assumed
> it
> had not.)
> Dear All
> We are seeing far more regular issues with v$session_longops causing a
> ORA-03113 when you try and select from it since we upgraded to the
> terminal
> release of 8.1.7 and at roughly the same time moved from Tivoli to Veritas
> for our RMAN backup back-end.
> Metalink says fixed in 9.2 which we will go to in due course but not for a
> few more months (I know we should be there already but....). Other than
> that
> it says you have to bounce your DB which we can only do at weekends - so
> if
> the problem occurs on a Monday we are without backups all week.
> I would like to know if anybody has any knowledge of what causes
> v$session_longops to go "bad" (so I can avoid it), or how to work around
> it
> when it is bad (Metalink says try setting hash_joins_enable FALSE but that
> does not work for me). I see one backport request for a fix in Metalink
> but
> nothing to say it ever got done or if so for my platform (probably not as
> I
> rasied a TAR and they denied any existance of a backport) - so any
> knowledge
> of a backport would be appreciated too.
> Many thanks
> Tim Onions - Oracle DBA
> _________________________________________________________________
> Winks & nudges are here - download MSN Messenger 7.0 today!
> --

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

Received on Wed May 18 2005 - 12:40:02 CDT

Original text of this message