Home / DBAdmin-Tools / mon_buffer
Name Modified Size InfoDownloads / Week
Parent folder
mon_buffer.sh 2020-05-11 1.7 kB
README 2020-05-11 1.8 kB
Totals: 2 Items   3.5 kB 0
Dear IIUG,

I made a shell script for buffer monitoring, the file is attached.

Thanks

Vagner Pontes
Database Admnistrator

Yoshitec Informatica
http:www.yoshitec.com.br

----------------------[ mon_buffer output ]-------------------------------

Fri Jan 18 10:10:03 EDT 2002
OSF1 pps1 V4.0 1530 alpha
############################################################

   Report - Buffer Utilization

############################################################

Total Buffers: 1205200

   PARTNUM TABLE/INDEX            BUFFERS USERS     % TOT
   3157294 debitar_cartoes         174093     5     14.45
   3146913 notasnaoemitidas         99696     0      8.27
   3145965 estado_opcao             93447   292      7.75
   3146044 notafiscal               63186     0      5.24
   3146016 criar_cartoes            52549     0      4.36
   3145923 systabauth               39880     0      3.31
   3151008 resumobanco              39646     1      3.29
   3146282 promoservico             36350     1      3.02
   9437191 mimo                     29302   294      2.43
   3146042 mimo                     28985   294      2.40
   9437202 mimo_saldo               27922   188      2.32
   3145777 historico_mimo           26206     0      2.17
   9437203 ms_saldo_1               23751   188      1.97
   3149793 eliminar_cartoes         18577     0      1.54
   3145852 cep                      15865    24      1.32
   3152576 numero                   10691     0      0.89
   3162660 sibs_online              10601     1      0.88
   3155521 ms_saldo_2                9936     1      0.82
   3149797 pedidohabilitar           8856     0      0.73
   9437195 i_mimo_msisdn             7986     3      0.66
   3149795 repor_preactivados        7156     0      0.59

_________________________________________________________
Source: README, updated 2020-05-11