Logstat Command Output – List of Active Processes
The List of Active Processes provides information on processes currently active in the logging system. This section has the following fields:
ID
Indicates the internal logging system ID for a process
PID
Indicates the process ID
TYPE
Indicates the type of the active process. The type field can be:
FCT—a DBMS Server running Fast Commit
SLAVE—a DBMS Server not running Fast Commit
ARCHIV—the archiver process
MASTER—the recovery process
OPEN_DB
Indicates the number of times the server opened a database. The recovery process and archiver each have their own database opened at all times, while the server is the process that opens the databases.
WRITE
Indicates the number of writes this process has performed in the logging system
FORCE
Indicates the number of times this process requested that a log buffer be forced to disk
WAIT
Indicates the number of times any transaction in this process needed to wait for a logging system-related reason
BEGIN
Indicates the number of transactions started by this process
END
Indicates the number of transactions ended by this process