SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 01:09 PM
| ||||
| ||||
 Package cache hit ratio, Hi , i am facing problem in package cache hit ratio its between 47-45% which is very less:- here are my configuration related to package cache:- Catalog cache size (4KB) (CATALOGCACHE_SZ) = 2500 Package cache size (4KB) (PCKCACHESZ) = 2500 Max number of active applications (MAXAPPLS) = 100 Average number of active applications (AVG_APPLS) = 30 Indicator Name = db.pkgcache_hitratio Value = 45 Evaluation timestamp = 12-12-2007 09:22:02.917262 Alert state = Alarm Formula = ((1- (476233/863736))*100) i tried increasing the PCKCACHESZ to 3480 but the the hit ratio doesn't increase. any help in this regards much appreciated. Regards, Ramchandra      |
|
02-27-2008, 01:09 PM
| ||||
| ||||
| Re: Package cache hit ratio, If you're running version 9 I'd suggest enabling STMM. This should take the guess-work out of tuning. It's tricky to give any other suggestions without knowing more about the workload you're running. It could be that there is very little query reuse with your workload and no amount of tuning will help. Can you provide some more information about your workload's characteristics? For instance, are you running static or dynamic SQL? Are there paramter markers in your queries, or are things hard coded? Any other information you can provide would be helpfull. Thanks, Adam On Dec 12, 1:34 am, Ramchandra <ramchandr...@gmail.com> wrote: > Hi , > > i am facing problem in package cache hit ratio its between 47-45% > which is very less:- > > here are my configuration related to package cache:- > > Catalog cache size (4KB) (CATALOGCACHE_SZ) = 2500 > Package cache size (4KB) (PCKCACHESZ) = 2500 > Max number of active applications (MAXAPPLS) = 100 > Average number of active applications (AVG_APPLS) = 30 > > Indicator Name = db.pkgcache_hitratio > Value = 45 > Evaluation timestamp = 12-12-2007 > 09:22:02.917262 > Alert state = Alarm > Formula = ((1- > (476233/863736))*100) > > i tried increasing the PCKCACHESZ to 3480 but the the hit ratio > doesn't increase. > > any help in this regards much appreciated. > > Regards, > Ramchandra |
Linear Mode
