Win2K + Oracle8.1.7
svrmgrl>alter system set log_archive_max_processes=1;
System altered.
其间database没有重启过(init.ora也已经是这个参数值了)
但是过了一段时间,arch进程数就超过了定义的max值
alrt.log显示:
ARC4: STARTING ARCH PROCESSES
ARC0 started with pid=69
Sat Oct 22 07:26:41 2005
ARC0: Archival started
Sat Oct 22 07:26:41 2005
ARC4: STARTING ARCH PROCESSES COMPLETE
为什么该参数会无效?
LOG_ARCHIVE_MAX_PROCESSES specifies the number of archiver background processes
(ARC0 through ARC9) Oracle initially invokes.
++ If the LOG_ARCHIVE_START initialization parameter has the value true, this value is evaluated at
instance startup.
++ Otherwise, this parameter is evaluated when the archiver process is first invoked by SQL*Plus or
SQL syntax.
-----------------------------------------------------------------------------------------
LOG_ARCHIVE_MAX_PROCESSES specifies the number of archiver background processes (ARC0 through ARC9) Oracle initially invokes.
If the LOG_ARCHIVE_START initialization parameter has the value true, this value is evaluated at instance startup.
Otherwise, this parameter is evaluated when the archiver process is first invoked by SQL*Plus or SQL syntax.
The actual number of archiver processes in use may vary subsequently based on archive workload