User status: onstat -u Flags

Flags in position 1

B - Waiting on a buffer

C - Waiting on a checkpoint

G - Waiting on a logical log buffer write

L - Waiting on a lock

S - Waiting on a mutex

T - Waiting on a transaction

Y - Waiting on a condition

X - Waiting on a transaction rollback

Flags in position 2

* - Transaction active during I/O error

Flags in position 3

A - Dbspace backup thread

B - Begin work

P - Prepared for commit work

X - TP/XA prepeared for commit work

C - Committing work

R - Rolling back work

H - Heuristically rolling back work

Previous slide

Next slide

Back to first slide

View graphic version