sysseswts

The sysseswts table provides information on the amount of time that users wait for various database objects.

Column	Type	Description
sid	integer	Session ID
reason	char(50)	Description of reason for wait: Unspecified Buffer Lock Asynchronous I/O Mt yield 0 Mt yield n Mt yield Checkpoint Log I/O Log copy Condition Lock mutex Lockfree mutex Deadlock mutex LRUs mutex Tblspace mutex Log mutex Checkpoint mutex Mutex Mt ready Mt yield x Running
numwaits	integer	Number of waits for this reason
cumtime	float	Cumulative time waited for this reason (in microseconds)
maxtime	integer	Maximum time waited during this session for this reason