Neoview Management Dashboard Client Guide for Database Administrators (R2.3)

Table 6-5 QueryRTS Entity Attributes (continued)
Default Attribute
for Grid?
Default Attribute
for Graph?
DescriptionAttribute
YesNoSegment of the busiest Executor Server Process.BusiestESPSeg
YesNoProcessing node of the busiest Executor Server
Process.
BusiestESPCPU
YesNoProcess identification number of the busiest
Executor Server Process.
BusiestESPPIN
YesNoLocal civil time at which the query began
compilation.
CompileStartTS
YesNoLocal civil time at which query compilation
ended.
CompileEndTS
YesNoNumber of minutes required to compile the
query.
CompileTime
YesNoExecution processor time in seconds, calculated
by subtracting the execution start time from
the execution end time.
ExecTime
YesYesThe highest severity SQL error code returned
in relation to this query.
ErrorCode
YesNoNumber of rows inserted, updated, or deleted
by the query. The value is greater than 0 for
Insert, Update, or Delete queries for which end
statistics were received. It is –1 for queries in
progress or for which no end statistics were
received. It is 0 for SELECT queries for which
end statistics were retrieved.
NumRowsIUD
YesNoNumber of rows accessed by the disk process
or the file system to evaluate the statement.
RowsAcc
YesNoNumber of rows retrieved for the query.RowsRetr
YesNoNumber of i/o operations to or from disk for
the query.
DiskIOs
YesNoNumber of messages sent to the disk.MsgsToDisk
YesNoNumber of bytes written to disk.MsgBytesToDisk
YesYesNumber of lock waits (concurrency cost)LockWaits
YesYesCumulative number of times record locks were
escalated to file locks.
LockEscal
YesNoStatement type, one of insert, delete, update,
or select.
Type
YesNoEstimated number of rows to be accessed.
Estimated at the time the query is prepared.
EstCardinality
YesNoEstimated processor time, in seconds, required
to execute this query. Estimated at the time the
query is prepared.
EstCpuTime
YesNoEstimated time, in seconds, that will be spent
in waiting for operations, such as opening a
table, to complete. Estimated at the time the
query is prepared.
EstIdleTime
94 Using Entity Screen Information