Sybase 12.5.1, User Manual

Page: 131 / 210

APPENDIX A Data Items
User’s Guide
117
Procedure Owner Name
Version: 11.0 and later
Name of the owner of the active stored procedure.
Type: Result
Procedure Physical Reads
Version: 11.0 and later
Number of requests to execute a stored procedure, for which a read from sysprocedures
was necessary.
Type: Result
Procedure Statement
Number
Version: 11.0 and later
Statement number within a stored procedure. A single stored procedure line can
contain one or more statements.
Type: Key
Process ID
Version: 11.0 and later
Adaptive Server process identification number. Views that contain Process ID only
report on processes that are active as of the end of the sample period. Process ID is
mutually exclusive with Application Name in a view.
Type: Key
Process State
Version: 11.0 and later
Process state:
• 0 – None.
• 1 – alarm sleep.Waiting on an alarm.
• 2 – background. Adaptive Server process executing.
• 3 – bad status. Undetermined error condition.
• 4 – infected. Tagged by Adaptive Server as unprocessable.
• 5 – lock sleep. Waiting on a lock acquisition.
• 6 – received sleep. Waiting on a network read.
• 7 – runnable. Waiting to run according to priority and availability of CPU.
• 8 – running. Executing.
• 9 – send sleep. Waiting on a network send.
• 10 – sleeping. Paused for any other reason not listed here, such as: waiting on device
I/O (physical reads) or waiting for client activity.
• 11 – stopped. Process terminated.
• 12 – terminating. Process terminating.
• 13 – unknown. Process state undeterminable.
• 14 – remote I/O. Waiting on a remote (OMNI) server to complete an operation.
• 15 – synch sleep. Waiting to synchronize with some other server process(es) that are
working in parallel to execute a given query.
Type: Key
Process State Count
Version: 11.0 and later
Number of processes in a particular state.
Type: Result
Data item Description