Hp Neoview Release 2.4 Software Manuel d'utilisateur télécharger pdf (Page 109)

Table C-7 QUERY_RUNTIME_STATS_V1 Field Definitions (continued)

DescriptionData Type

Field Name (* means available only in

this view)

SQL error code, if any, returned in

response to this query. The value is 100

for completed SELECT, UPDATE, or

DELETE statements with actual end

statistics. The value is 0 for completed

INSERT queries or for uncompleted

queries. A negative number indicates

an execution-type error.

INTEGER SIGNED NO DEFAULTERROR_CODE

Number assigned to the query by

WMS. Value will be zero (0).

INTEGER SIGNED NO DEFAULTQUERY_INDEX*

Unique numeric ID for the service,

assigned by WMS. Corresponds to

SERVICE_NAME. Value will be (0).

INTEGER SIGNED NO DEFAULTSERVICE_INDEX*

Numeric form of the user ID, an

integer identifying the user.

INTEGER SIGNED NO DEFAULTUSER_ID

Total number of child Executor Server

Processes busy (as busy as or busier

than BUSY_THRESHOLD) during the

last interval.

INTEGER SIGNED NO DEFAULTNUM_ESPS_GT_THRESHOLD*

Total number of child Executor Server

Processes for the query.

INTEGER SIGNED NO DEFAULTNUM_CHILD_ESPS*

Total number of child Executor Server

Processes in a suspended state.

INTEGER SIGNED NO DEFAULTNUM_SUSPENDED_ESPS*

Amount of “space” type (static)

memory, in kilobytes, allocated

(reserved) for query processes (master

executor and ESPs) at the beginning of

query execution. Maximum value of

SQL_SPACE_ALLOCATED reached

over the life of the query.

INTEGER SIGNED NO DEFAULTSQL_SPACE_ALLOCATED*

1

Amount of “space” type (static)

memory, in kilobytes, actually used

for query processes (master executor

and ESPs) during query execution. It

should be less than or equal to the

SQL_SPACE_ALLOCATED value.

Maximum value of

SQL_SPACE_USED reached over the

life of the query.

INTEGER SIGNED NO DEFAULTSQL_SPACE_USED*

1

Amount of “heap” type (dynamic)

memory, in kilobytes, allocated

(reserved) for query processes (master

executor and ESPs) at the beginning of

query execution. The processes that

execute the query request this memory

during execution, thus the amount can

change as the query runs. Maximum

value of SQL_HEAP_ALLOCATED

reached over the life of the query.

INTEGER SIGNED NO DEFAULTSQL_HEAP_ALLOCATED*

1

VIEW NEO.HP_METRICS.QUERY_RUNTIME_STATS_V1 109

1 2 ... 104 105 106 107 108 109 110 111 112 113 114 ... 127 128

Commentaires sur ces manuels

Pas de commentaire