Home | Previous Page | Next Page   Administrative Utilities > The onstat Utility > onstat -g Monitoring Options >

The onstat -g ppf partition number | 0 Option

The onstat -g ppf option prints the partition profile for partition number; 0 prints profiles for all partitions. If TBLSPACE_STATS configuration parameter is set to 0, displays: Partition profiles disabled.

Example Output

Figure 79. onstat -g ppf Output
Partition profiles
partnum    lkrqs lkwts dlks  touts isrd  iswrt isrwt isdel bfrd  bfwrt seqsc rhitratio
0x100001   0     0     0     0     0     0     0     0     0     0     0     0 
0x100002   1506  0     0     0     416   4     0     4     1282  20    0     97
0x100003   15    0     0     0     5     0     0     0     20    0     0     75
0x1000a5   0     0     0     0     0     0     0     0     12    0     0     67
0x1000e3   4     0     0     0     1     0     0     0     4     0     0     25
0x200001   0     0     0     0     0     0     0     0     0     0     0     0
0x300001   0     0     0     0     0     0     0     0     0     0     0     0
0x400001   0     0     0     0     0     0     0     0     0     0     0     0  
Output Description

partnum
Partition number
lkrqs
Lock requests
lkwts
Lock waits
dlks
Deadlocks
touts
Remote deadlock timeout
isrd
Number of reads
iswrt
Number of rewrites
isdel
Deletes
bfrd
Buffer reads
bfwrt
Buffer writes
seqsc
Sequential scans
rhitratio
Ration of disk read to buffer read
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]