The onstat -s command displays the latches that are currently being held by userthreads for resources in shared memory.
Latches with lock or userthread set name address lock wait userthread physlog 4ebdf368 0 3dbc77d20 3dca48d20 physb1 4ebdf3e0 0 3dca48d20 3dc7bdaa8 physb2 4ebdf4e0 0 0 3dca48d20
Heading | Description | Format | See Also |
---|---|---|---|
name | The name of the resource upon which a latch has been acquired.
Name Description altlatch Alter table counter archive Archive bf[#] Buffer bh[#] Hash buffer chunks Chunks ckpt Checkpoints DBSpace DBSpace flushctl Flusher control flushr# Page cleaners locks Lock table lh[#] Lock hash lockfr Lock free list lockdl Deadlock list loglog Logical Log LRU# LRU queue physb1 Physical Log buffer 1 physb2 Physical Log buffer 2 physlog Physical Log pt Tblspace tblspace tblsps Tblspace table timestamp Timestamp trace Trace buffer trans Transactions txlk[#] Transaction list users User table userthreads User list |
Str | onstat -u onstat -g amx onstat -g lmx onstat -g wmx |
address | The in-memory address of the latch. | Hex | |
lock | Indicates if the lock on the resource is set. The code that indicates the lock status (1 or 0) is machine dependent | Dec | |
wait | The first address of the thread waiting for this resource. | Hex | |
userthread | The address of the userthread holding the latch. | Hex | onstat -u |
To discuss how Oninit ® can assist please call on +1-913-674-0360 or alternatively just send an email specifying your requirements.