onstat -g tpf command: Print thread profiles

Use the onstat -g tpf command to display thread profiles.

Figure 1: Syntax:

1  onstat   -g tpf tid

Specify the tid thread ID to print the profile for a specific thread. Set tid to 0 to display the profiles for all of the threads.

Example output

Figure 2: onstat -g tpf command output
onstat -g tpf 945

Thread profiles
tid lkreqs lkw dl to lgrs isrd iswr isrw isdl isct isrb lx bfr bfw lsus lsmx seq
945 1969   0   0  0  6181 1782 2069 13   0    0    0    0  16183 7348 743580 0    6  

Output description

tid
Thread ID
lkreqs
Lock requests
lkw
Lock waits
dl
Deadlocks
to
Remote deadlock timeout
lgrs
Log records
isrd
Number of reads
iswr
Number of writes
isrw
Number of rewrites
isdl
Number of deletes
isct
Number of commits
isrb
Number of rollbacks
lx
Long transactions
bfr
Buffer reads
bfw
Buffer writes
lsus
Log space currently used
lsmx
Max log space used
seq
Sequence scans