onstat -P command: Print partition information

Use the onstat -P command to display the partition number and the pages in the buffer pool for all of the partitions.


Syntax:

>>-onstat-- -P-------------------------------------------------><

For information about running onstat -P on a dump file created without the buffer pool, see Running onstat Commands on a Shared Memory Dump File.

Example output

Figure 1. onstat -P command output

Buffer pool page size: 2048
partnum  total    btree    data     other    dirty   
0        36       1        8        27       0      
1048577  2        0        0        2        0       
1048578  4        1        1        2        0       
1048579  23       10       12       1        0       
1048580  68       31       36       1        0       
4194309  3        0        1        2        0       

Totals:  3000     786      1779     435      0       
Percentages:
Data  59.30 
Btree 26.20 
Other 14.50 

Buffer pool page size: 8192
partnum  total    btree    data     other    dirty   
0        999      0        0        999      0       
5242881  1        0        0        1        0       

Totals:  1000     0        0        1000     0       
Percentages:
Data  0.00  
Btree 0.00  
Other 100.00

Output description

Buffer pool page size: The size, in bytes, of the buffer pool pages.
partnum: The partition number.
total: The total number of partitions.
btree: The number of B-tree pages in the partition.
data: The number of data pages in the partition.
other: The number of other pages in the partition.
dirty: The number of dirty pages in the partition.