The history of changes for a Monitored Component (process) is also stored in the database to give an audit. Every change of state is logged in this table. The table is periodically cleared of old logging data by the SPDB_tidy housekeeping script, so the customer is able to configure how much history to keep. The table stores the 'before' and 'after' values from sp402_component_states.

Housekeeping

This table is tidied by sp_dbtidy's Audit group.

Table Definition

Field	Type	Default	Nullable
component_no	number
sequence_no	number
timestamp	date
user_id	varchar2(50)
old_status	number
new_status	number
old_pid	number
new_pid	number

Keys

Column Descriptions

Field	Description
component_no	Component identifer.
sequence_no	For ordering queries- several events may happen at the same time.
timestamp	Time at which the change happened (Uses the time zone of the DBMS server machine).
user_id	Requesting user for change (for starting/shutdown on command from administrator).
old_status	Old value for what the process is currently doing e.g. starting/initialising/stopping etc.
new_status	New value for what the process is currently doing e.g. starting/initialising/stopping etc.
old_pid	Old value for PID of the process currently running for this component.
new_pid	New value for PID of the process currently running for this component.

Browser not supported