Procedure activity
(DBNAME, NAME)
| Name | Data Type | Description |
|---|---|---|
| DBNAME | string(32) | Database name |
| NAME | string(132) | Procedure name |
| TYPE | string(12) | Procedure type |
| USECOUNT | long | Total number of times procedure was used, since oldest data available |
| CPUTIME | long | Total CPU time, in milliseconds, over all procedure calls, since oldest data available |
| WAITTIME | long | Total wait time, in milliseconds, over all procedure calls, since oldest data available |
| ELAPSEDTIME | long | Total elapsed time, in milliseconds, over all procedure calls, since oldest data available |
| OTHERTIME | long | Total other time, in milliseconds, over all procedure calls, since oldest data available |
| MINCPUTIME | long | Minimum CPU time per procedure call, in milliseconds, since oldest data available |
| MAXCPUTIME | long | Maximum CPU time per procedure call, in milliseconds, since oldest data available |
| AVGCPUTIME | long | Average CPU time per procedure call, in milliseconds, since oldest data available |
| MINWAITTIME | long | Minimum wait time per procedure call, in milliseconds, since oldest data available |
| MAXWAITTIME | long | Maximum wait time per procedure call, in milliseconds, since oldest data available |
| AVGWAITTIME | long | Average wait time per procedure call, in milliseconds, since oldest data available |
| MINELAPSEDTIME | long | Minimum elapsed time per procedure call, in milliseconds, since oldest data available |
| MAXELAPSEDTIME | long | Maximum elapsed time per procedure call, in milliseconds, since oldest data available |
| AVGELAPSEDTIME | long | Average elapsed time per procedure call, in milliseconds, since oldest data available |
| MERGESTATUS | long | Internal-use merge status; created by Surveillance |
| CPUTIME_DELTA | double | Delta total CPU time, in milliseconds |
| CPUTIME_OVERALL | double | Total CPU time, in milliseconds, since collection started |
| WAITTIME_DELTA | double | Delta total wait time, in milliseconds |
| WAITTIME_OVERALL | double | Total wait time, in milliseconds, since collection started |
| ELAPSEDTIME_DELTA | double | Delta total elapsed time, in milliseconds |
| ELAPSEDTIME_OVERALL | double | Total elapsed time, in milliseconds, since collection started |
| USECOUNT_DELTA | double | Delta number of times procedure was used |
| Attributes: | MDA |
|---|---|
| Minimum database version: | 15.0.3 |