By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,017 Members | 979 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,017 IT Pros & Developers. It's quick & easy.

Package cache hit ratio,

P: n/a
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
Dec 12 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.comwrote:
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
Dec 12 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.