Re: RECO process status

From: sfama <silvia.fama_at_googlemail.com>
Date: 13 Jul 2006 06:12:40 -0700
Message-ID: <1152796360.156801.112100@75g2000cwc.googlegroups.com>

sybrandb ha scritto:

> sfama wrote:
> > Hi!
> >
> > I can see on the system where Oracle server is installed, that the RECO
> > process is active.
> > How can I see if is it enabled or disabled? Is there a table that
> > stores this information or an SQL command I can use?
> >
> > Thank you!
>
> No version, and the answer is version dependent. Please *always*
> specify a version
>
> In 9i and before there is v$bgprocess. If the addr column not equals
> '00' the process is used.
> In 10g you could run
> select program from v$process where background =1
>
> Note: if there is a RECO process, it is used. If you have database
> links you have the RECO process.
>
> --
> Sybrand Bakker
> Senior Oracle DBA

Thanks!

Also cause I needed information about version 9i ans 10g!

Now, may you explain why, if I have a transaction in prepared state and it is into the DBA_2PC_PENDING, RECO never recovers it (it's active and enabled)?
Maybe it makes check after a long time or what?

Thanks again! Received on Thu Jul 13 2006 - 08:12:40 CDT