Name | Modified | Size | Downloads / 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 _________________________________________________________