Oracle 5.0, Reference Manual

Page: 754 / 3232

General Thread States
734
The thread is waiting for the client to send a new statement to it.
•
Statistics
The thread is producing server-status information.
•
Table Dump
The thread is sending table contents to a slave server.
•
Time
Unused.
8.10.2. General Thread States
The following list describes thread
State
values that are associated with general query processing
and not more specialized activities such as replication. Many of these are useful only for finding bugs in
the server.
•
After create
This occurs when the thread creates a table (including internal temporary tables), at the end of the
function that creates the table. This state is used even if the table could not be created due to some
error.
•
Analyzing
The thread is calculating a
MyISAM
table key distributions (for example, for
ANALYZE TABLE
).
•
checking permissions
The thread is checking whether the server has the required privileges to execute the statement.
•
Checking table
The thread is performing a table check operation.
•
cleaning up
The thread has processed one command and is preparing to free memory and reset certain state
variables.
•
closing tables
The thread is flushing the changed table data to disk and closing the used tables. This should be a
fast operation. If not, you should verify that you do not have a full disk and that the disk is not in very
heavy use.
•
converting HEAP to MyISAM
The thread is converting an internal temporary table from a
MEMORY
table to an on-disk
MyISAM
table.
•
copy to tmp table
The thread is processing an
ALTER TABLE
statement. This state occurs after the table with the new
structure has been created but before rows are copied into it.
•
Copying to group table
If a statement has different
ORDER BY
and
GROUP BY
criteria, the rows are sorted by group and
copied to a temporary table.