Sybase 12.5.1, Руководство пользователя

Страница: 130 / 210

Table of data items and definitions
116
Historical Server
Procedure Database ID
Version: 11.0 and later
Database ID of the active stored procedure.
Type: Key
Procedure Database
Name
Version: 11.0 and later
Database name of the active stored procedure.
Type: Key
Procedure Elapsed Time
Version: 11.0 and later
Number of seconds elapsed during a stored procedure execution. All statistic types
valid with this data item report time in units of seconds. For example, “Procedure
Elapsed Time”, “Average for Session” reports the average number of elapsed seconds
per procedure execution.
Type: Result
Procedure Execution
Class
Version: 11.5 and later
Configured execution class, if any, for a given stored procedure.
Type: Result
Procedure Execution
Count
Version: 11.0 and later
Number of times a stored procedure, or a line in a stored procedure, was executed.
Type: Result
Procedure Header Size
Version: 11.0 and later
Amount of memory in bytes allocated for the procedure header.
Type: Result
Procedure Hit Percent
Version: 11.0 and later
Percentage of times that a procedure execution found the procedure’s query plan in
procedure cache and available for use.
Type: Result
Procedure ID
Version: 11.0 and later
Active stored procedure. Active indicates the top-level stored procedure was called.
Type: Key
Procedure Line Number
Version: 11.0 and later
Stored procedure line number.
Type: Key
Procedure Line Text
Version: 11.0 and later
Entire text of the stored procedure.
Type: Result
Procedure Logical Reads
Version: 11.0 and later
Number of requests to execute a stored procedure, whether satisfied from procedure
cache or with a read from sysprocedures.
Type: Result
Procedure Name
Version: 11.0 and later
Name of the active stored procedure.
Type: Result.
Data item Description