Oninit Logo
The Down System Specialists
+1-913-732-8892
+44-2081-337529
Introduction Health Check Standby Admin Remote Admin Remote Monitoring Backup and Restore Custom Support Down Systems
Unix SQL Advanced SQL 4GL Applications Advanced 4GL IDS Admin Migrating to V14 IDS Performance Managing & Optimising SPL and Triggers IDS V14 Upgrading Very Old Versions Custom Training
Onstat Guide Error Code Guide Reference Datablades The Dumb DBA Sysmaster Fault Finder
Co-Location Web Hosting Managed Servers Web Development
BenchMark Tookkit RegExp Datablade
Partnerships Contact
Onstat
-g act -g afr -g all -g amx -g aqt -g arc -g ath -g btc -g buf -g cac -g cdr -g cluster -g cdr config -g cfg -g cmsm -g con -g cpu -g dbc -g ddr -g dic -g dis -g dll -g dmp -g dri -g dsc -g dsk -g dss
-g env -g ffr -g glo -g grp -g imc -g ioa -g iob -g iof -g iog -g ioq -g iov -g ipl -g lap -g laq -g lmm -g lmx -g lsc -g mem -g mgm -g nbm -g nif -g nsc -g nsd -g nss -g nta -g ntd -g ntm -g ntt -g ntu
-g opn -g osi -g pgp -g pos -g ppd -g ppf -g pqs -g prc -g proxy -g qst -g rah -g ras -g rbm -g rcv -g rep -g rea -g rss -g sch -g scn -g sds -g seg -g ses -g sle -g smb -g smx -g spi -g sql -g src -g ssc -g stk -g stm -g stq -g sts -g sym -g sync
-g rwm -g tgp -g tpf -g ufr -g wai -g vpcache -g wmx -g wst
-b/-B -F -g cac -g dic -g dsc -g prc -g ssc -g vpcache -h -p -X
-t/-T -g buf -g lap -g opn -g ppf -g scn
-g cat -g cdr -g cdrconfig -g ddr -g dss -g dtc -g grp -g nif -g que -g rcv -g rep -g rqm -g sync
-g cluster -g cmsm -g dri -g ipl -g laq -g proxy -g rss -g sds -g smx
-R -g afr -g ffr -g lmm -g lsc -g mem -g mgm -g nbm -g rbm -g seg -g ses -g stm -g stq -g ufr
-g imc -g nsc -g nsd -g nss -g nta -g ntd -g ntm -g ntt -g ntu
-G -u -x -g env -g his -g pqs -g ses -g sql
-g act -g ath -g cpu -g rea -g sle -g stk -g sts -g tpf -g wai -g wst
-a -b/-B -C -c -d/-D -F -f -G -h -i -j -k/-K -L -l -m -o -P -p -R -r -s -t/-T -u -X -x -z

onstat -h Buffer Hash Chain Length Histogram

The onstat -h command provides information on the buffer header hash chain used to access pages in the buffer pool. 

Buffer pool page size: 2048

buffer hash chain length histogram
   # of chains         of len
       3021028              0
        616286              1
        238274              2
        141138              3
         17567              4
         15102              5
         12672              6
         17334              7
         18243              8
         21599              9
         29354             10
         41973             11
          3568             12
           164             13
             2             14
       4194304   total chains
       2999950   hashed buffs
       3000000    total buffs

Output Description

Heading Description Format See Also
# of chains A count of the number of hash chains for which the length for members of that chain is the same. Dec onstat -b
of len The length of the chains. Dec  
total chains The number of hash chains (buckets) created. Dec  
hashed buffs The number of buffer headers hashed into the hash buckets. Dec  
total buffs The number of buffers in the buffer pool. Dec  

Notes

In some earlier versions, the onstat -h command does not show up in the normal onstat command usage.

Monitoring and Tuning

Tuning to the hash chain is performed indirectly by tuning the number of buffers. As pages are read into the buffer pool, the page number is hashed to a value for one of the hash buckets. Since there are only a limited number of hash buckets, multiple page numbers will hash to the same value and thus the same hash bucket, creating a chain. Although the onstat -h command doesn't show the length of each individual hash bucket, it does show the total number of hash buckets with a particular length.

To discuss how Oninit ® can assist please call on +1-913-674-0360 or alternatively just send an email specifying your requirements.