Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

difference between moncachedObject.TotalSizeKB and monCachedObject.CachedKB

Hi team,

I was reading the definition of monCachedObject (sybase 15.5) and I actually don't understand the difference between

CachedKB | int | Number of kilobytes of the cache the object is occupying

TotalSizeKB |int | Partition size, in kilobytes.

Below is an example for one table on my database

CachedKBTotalSizeKB
33703088429144

Does it mean my table is using 3370308 Kb of the cache or 8429144 Kb of the cache

Thanks

Simon

Tags:
Former Member
replied

TotalSizeKB is the size of that partition or table on disk for the given object id & index id.    CachedKB is how much of it is in cache.   So in the above case - assuming the IndexID=0 and we are talking about the table, then ~3GB of the table is in cache, and the table is ~8GB in size.   Seems a bit high - either table is widely hit (e.g. a lot of reports, or it is a fairly volatile or highly referenced table) or indexing isn't very distinctive

1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question