The state filter bar allows you to display specific states in the view. If more than six states are available in a Teradata Database system, you can select another state from the Overflow Menu to replace the state in the last position.
The state filter buttons provide a count of sessions for each state category. Click any button to filter for the selected state or select a state from the list. For example, click Delay to display the sessions running a query that is queued and waiting to run in the selected system. Hover over a state filter button to display the expanded content for large, abbreviated numbers or truncated state names.
- All
- Sessions currently running in the selected Teradata Database system
- Not Idle
- Sessions in any state except idle
- Active
- Sessions running a query that is in progress
- Block
- Sessions running a query that is waiting for a locked resource, such as a database table or view
- Defer
- Sessions running a query that is in deferred queue waiting to run.
- Delay
- Sessions running a query that is queued waiting to run
- Abort
- Sessions running a query that is in the process of aborting (rolling back changes made by the query)
- Resp
- Sessions running a query that has completed and is sending (responding) spooled data back to the user
- Idle
- Sessions not currently running a query
- Parse
- Sessions running a query that is being parsed. It has not begun to execute.
- Other
- Sessions whose status is unknown and do not fall into any of the above categories
- QTDelayed
- Sessions delayed due to a queue table restriction
- SesDelayed
- Utility sessions that are in the workload delay queue
- Response-Held
- In SLES 11, sessions running a query whose response is being held until a specified number of seconds elapses