hi, in our installation we have 2GB RAM, BUFFPOOLSIZE=65536,LOGPOOLSIZE=512 With these settings we have a DB-CACHE-HIT-PCT between 98.5% and 99.5% (we reset the values every day).
Best regards Chris > -----Urspr�ngliche Nachricht----- > Von: Pothula S Paparao [SMTP:[EMAIL PROTECTED]] > Gesendet am: Dienstag, 27. November 2001 08:04 > An: [EMAIL PROTECTED] > Betreff: logpool size for 2 gb RAM > Wichtigkeit: Hoch > > how much do i have to set the value for LOGPOOLSIZE for 2gb RAM . > my buffpoolsize is already set to 262144. even then, my db cache hit pct > is > well below 99% i,e. 96% > > > thanks in advance. > regards > sreekumar.
