Re: RECO process status

From: sybrandb <sybrandb_at_gmail.com>
Date: 13 Jul 2006 03:42:02 -0700
Message-ID: <1152787322.541471.308800@m73g2000cwd.googlegroups.com>

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

Received on Thu Jul 13 2006 - 05:42:02 CDT