In a small test, I can confirm there are no rollbacks occuring. There are mostly SELECTS and minor updates.
What other aspects will play a role in the catalog cache hit rate?
Thanks
From: "Anhaus, Thomas" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
CC: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
Subject: RE:Catalog Cache hit rate, how to increase?
Date: Mon, 17 Feb 2003 11:17:17 +0100
John Doed wrote :
>From the DBM GUI I see my Data Cache is 99%-100% but my Catalog hit rate is
>anywhere between 70%-85%. I tried increasing CAT_CACHE_SUPPLY significantly
>but that actually lowered the hit rate average to the mid 70's (it was low
>80's before).
>How do I get Catalog Cache hit rate to 100%?
It is not always possible to increase the catalog hit rate,
because some events require to empty the cache completely.
One of this events is a transaction rollback, others are DDL statements
executed in your session.
If increasing the parameter CAT_CACHE_SUPPLY does not improve your hit rate,
it seems that it's caused by your application profile.
Regards,
Thomas
--
Thomas Anhaus
SAP DB, SAP Labs Berlin
[EMAIL PROTECTED]
http://www.sapdb.org/
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
_________________________________________________________________
MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
