Re: diff between FGRD and ARCH in v$archived_log.creator column

[Vladimir Begun]

[EMAIL PROTECTED] wrote:
What is FGRD and ARCH in v$archived_log.creator column.

I see something like below in my db.
select recid,creator from v$archived_log
Oracle9i Database Reference Release 2 (9.2)
V$ARCHIVED_LOG
CREATOR VARCHAR2(7)
Creator of the archivelog:
    * ARCH - ARCH process
    * FGRD - Foreground process
    * RMAN
    * SRMN - RMAN at standby
    * LGWR - LGWR process
SQL> select recid,creator from v$archived_log where recid > 55;

    RECID CREATOR
--------- -------
       56 ARCH
       57 ARCH
       58 FGRD
SQL>  ALTER SYSTEM ARCHIVE LOG CURRENT;

System altered.

SQL> select recid,creator from v$archived_log where recid > 55;

    RECID CREATOR
--------- -------
       56 ARCH
       57 ARCH
       58 FGRD
       59 FGRD
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Vladimir Begun
 INET: [EMAIL PROTECTED]
Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).