M
Mike Fechner
Guest
How large is your database? -B of 1000 or 1100 is nothing. Try 10000 or 50000 to see a first result. But monitor your free RAM. Don't increase -B for causing paging. Am 1. Juli 2015, um 06:50, schrieb "vithal.kattikar@hgst.com" bounce-vithalkattikarhgstcom@community.progress.com : Buffer hit ratio. Thread created by vithal.kattikar@hgst.com Hi All, In one of our database the buffer hit ratio value of 32% , So I increased value of -B parameter from 1000 to 1100 by editing the parameter file. First two days hit ration was showing 100% , suddenly it again decreased to 50% . Please suggest whether to increase -B value further. Editing pf file to increase -B value is the good method or we can use proutil dbname -C increaseto command. Stop receiving emails on this subject. Flag this post as spam/abuse.
Continue reading...
Continue reading...