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
YesNoWarning returned to the stats collector by RTS.StatsErrorCode
YesNoFor Master Executor and ESPs, kilobytes of SQL
space allocated. This type of memory continues
to grow during query processing. (Compare
SQLHeapAlloc.)
SqlSpaceAlloc
YesNoFor Master Executor and ESPs, kilobytes of SQL
space actually used. This type of memory
continues to grow during query processing.
(Compare SQLHeapUsed.)
SqlSpaceUsed
YesNoFor Master Executor and ESPs, kilobytes of SQL
heap allocated. This type of memory fluctuates
during query processing. (Compare
SQLSpaceAlloc.)
SqlHeapAlloc
YesNoFor Master Executor and ESPs, kilobytes of SQL
heap actually used. This type of memory
continues fluctuates during query processing.
(Compare SQLSpaceUsed.)
SqlHeapUsed
YesNoApproximate total processing node(CPU) time,
in microseconds, used by Master Executor and
ESPs for this query.
SqlCpuTime
YesNoFor Executor in disk process, kilobytes of
memory space allocated. This type of memory
continues to grow during query processing.
(Compare EidHeapAlloc.)
EidSpaceAlloc
YesNoFor Executor in disk process, kilobytes of
memory space actually used. This type of
memory continues to grow during query
processing. (Compare EidHeapUsed.)
EidSpaceUsed
YesNoFor Executor in disk process, kilobytes of heap
allocated. This type of memory fluctuates
during query processing. (Compare
EidSpaceAlloc.)
EidHeapAlloc
YesNoFor Executor in disk process, kilobytes of heap
actually used. This type of memory continues
fluctuates during query processing. (Compare
EidSpaceUsed.)
EidHeapUsed
YesNoEstimated number of rows to be accessed for
the query. Estimated at the time the query is
prepared.
EstAccessedRows
YesNoEstimated number of rows to be used by the
query. Estimated at the time the query is
prepared.
EstUsedRows
Table Entity
The Table entity screen displays information about tables or materialized views that have outdated
or missing statistics. The grid in the bottom part of the display includes one row for each table
or materialized view that has outstanding missing statistics. As statistics are updated, the
corresponding tables or materialized views disappear from the display.
Table entity information can be useful when you are trying to understand why a query is
performing badly, because missing or obsolete statistics can cause poor query performance. Table
fragmentation (requiring a REORG on the table) is another possible cause of poor query
96 Using Entity Screen Information