Oracle 5.0, Reference Manual

Page: 752 / 3232

Thread Command Values
732
•
Command
and
State
indicate what the thread is doing.
Most states correspond to very quick operations. If a thread stays in a given state for many seconds,
there might be a problem that needs to be investigated.
•
Time
indicates how long the thread has been in its current state. The thread's notion of the current
time may be altered in some cases: The thread can change the time with
SET TIMESTAMP =
value
. For a thread running on a slave that is processing events from the master, the thread time is
set to the time found in the events and thus reflects current time on the master and not the slave.
•
Info
contains the text of the statement being executed by the thread, or
NULL
if it is not executing
one. By default, this value contains only the first 100 characters of the statement. To see the
complete statements, use
SHOW FULL PROCESSLIST
.
The following sections list the possible
Command
values, and
State
values grouped by category. The
meaning for some of these values is self-evident. For others, additional description is provided.
8.10.1. Thread Command Values
A thread can have any of the following
Command
values:
•
Binlog Dump
This is a thread on a master server for sending binary log contents to a slave server.
•
Change user
The thread is executing a change-user operation.
•
Close stmt
The thread is closing a prepared statement.
•
Connect
A replication slave is connected to its master.
•
Connect Out
A replication slave is connecting to its master.
•
Create DB
The thread is executing a create-database operation.
•
Daemon
This thread is internal to the server, not a thread that services a client connection.
•
Debug
The thread is generating debugging information.
•
Delayed insert
The thread is a delayed-insert handler.
•
Drop DB
The thread is executing a drop-database operation.
•
Error
•
Execute