Filter
Top Products
Utilities 7-97
Option Descriptions
-s Option
Use the -s option to display general latch information. (Refer to page 2-41 for
more details about latches.) You can interpret output from this option as
follows:
name identifies the resource the latch controls:
archive
bf
bh
chunks
ckpt
dbspace
flushctl
flushr
locks
loglog
LRU
physb1
physb2
physlog
pt
tblsps
users
archiving
buffers
hash buffers
chunk table
checkpoints
dbspace table
page flusher control
page cleaners
lock table
logical log
LRU queues
first physical log buffer
second physical log buffer
physical log
tblspace tblspace
tblspace table
user table
address is the address of the latch. This address appears in the -u
(users) output wait field if a process is waiting for the latch.
lock indicates if the latch is locked and set. The codes that indicate
the lock status (1 or 0) are machine-dependent.
wait indicates if any user process is waiting for the latch.
user is the shared-memory address of the owner of the latch. This
address identifies the user process in the -u (users) output.