This view shows the CPU utilization, page I/Os, and current process state for all processes in the Adaptive Server.
For the most recent sample interval, the login name, Process ID and Kernel Process ID are given for each process, together with its current process state.
The view also presents each process’s connect time, total page I/Os and CPU utilization time, accumulated since the start of the recording session.
hs_create_view process_activity, "Login Name", "Value for Sample", "Process ID", "Value for Sample", "Kernel Process ID", "Value for Sample", "Connect Time", "Value for Session", "Page I/O", "Value for Session", "CPU Time", "Value for Session", "Current Process State", "Value for Sample"
