Documentation Home
Oracle Enterprise Manager for MySQL Database User's Guide
Download this Manual
PDF (US Ltr) - 0.7Mb
PDF (A4) - 0.7Mb


Oracle Enterprise Manager for MySQL Database User's Guide  /  Metrics  /  Sys Schema Processes Metrics

6.34 Sys Schema Processes Metrics

Lists the Sys Schema Processes metrics and provides a brief description of each.

Table 6.34 Sys Schema Processes Metrics

NameDescription
CommandThe command type the process is running.
Connection IdThe id of the connection for this process.
Current MemoryMemory allocated by the process.
Current StatementThe currently running SQL statement for this process.
DatabaseThe current default database for this process.
Full ScanDid the currently running SQL statement for this process cause a full table scan? YES/NO.
Last StatementThe previous SQL statement ran by this process, if no SQL statement is currently running.
Last Statement LatencyLatency of the previously running SQL statement for this process.
Last WaitCause of the last wait for this process.
Last Wait LatencyLatency of the last wait for this process.
Lock LatencyThe time spent waiting for locks of the currently running SQL statement for this process.
PidOperating system process ID of the client using this process.
Program NameProgram name of the client using this process.
ProgressPercentage of work completed of the currently running SQL statement for this process.
Rows AffectedRows modified by the currently running SQL statement for this process.
Rows ExaminedRows examined by the currently running SQL statement for this process.
Rows SentRows sent to the client by the currently running SQL statement for this process.
SourceSource code location of the current/last wait in the server for this process.
StateThe current state for this process.
Statement LatencyLatency of the currently running SQL statement for this process.
Thread IdThe thread id for this process.
TimeThe time, in seconds, that this process has been within the current state.
Tmp Disk TablesOn-disk temporary tables created by the currently running SQL statement for this process.
Tmp TablesTemporary tables created by the currently running SQL statement for this process.
Transaction AutocommitAutocommit state of the current transaction for this process.
Transaction LatencyLatency of the current transaction for this process.
Transaction StateState of the current transaction for this process.
UserThe user the process runs as.