v$archived_log creator 介绍
?ARCH - ARCH process
?FGRD - Foreground process
?RMAN
?SRMN - RMAN at standby
?LGWR - LGWR process --dg
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning and Data Mining options
SQL> select creator,count(*) from v$archived_log group by creator;
CREATOR COUNT(*)
------- ----------
ARCH 29246
SQL> alter system switch logfile;
System altered.
SQL> select creator,count(*) from v$archived_log group by creator;
CREATOR COUNT(*)
------- ----------
ARCH 29247
SQL>
SQL> alter system archive log current;
System altered.
SQL> select creator,count(*) from v$archived_log group by creator;
CREATOR COUNT(*)
------- ----------
ARCH 29247
FGRD 1
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/24577884/viewspace-1070192/ ，如需转载，请注明出处，否则将追究法律责任。
