Oracle-L: Re: Archiver process in 7.3.4

From: <Jared.Still_at_radisys.com>
Date: Wed, 05 Jun 2002 11:03:45 -0800
Message-ID: <F001.0047569C.20020605110345@fatcity.com>

This might help:

select

   b.name,
   s.sid,
   s.serial#,
   s.status

from v$session s, v$bgprocess b

where s.paddr = b.paddr
order by b.name, sid
/

If the archiver is started, there will be an 'ARCH' process.

Jared

"Alex Hillman" <ahillman_at_erols.com>
Sent by: root_at_fatcity.com
06/05/2002 10:13 AM
Please respond to ORACLE-L

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        Archiver process in 7.3.4

Anybody knows how to get status of archiver process programmatically in Oracle 7.3.4?
This information is available from v$instance in Oracle 8+.

Alex Hillman

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Alex Hillman
INET: ahillman_at_erols.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: Jared.Still_at_radisys.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------