Livecache data cache usage - table monitor_caches

[Former Member]

Hi Team,

We have a requirement of capturing the Data cache usage of Livecache on an hourly basis.

Instead of doing it manually by going into LC10 and copying the data into an excel, is there a table which captures this data on a periodic basis which we can use to get the report at a single shot.

"monitor_caches" is one table which holds this data, but we are not sure how we can get the data from this table. Also, we need to see the contents of this table, we are not sure how we can do that.

As "monitor_caches" is a maxdb table I am not sure how I can the data from this table. I have never worked on Maxdb before.

Has anyone had this requirement.

Warm Regards,

Venu

[former_member188883 · Accepted solution]

Hi,

For Cache usage below tables can be referred

Data Cache Usage - total (table MONITOR_CACHES)

Data Cache Usage - OMS Data (table MONITOR_CACHES)

Data Cache Usage - SQL Data (table MONITOR_CACHES)

Data Cache Usage - History/Undo (table MONITOR_CACHES)

Data Cache Usage - OMS History (table MONITOR_CACHES)

Data Cache Usage - OMS Rollback (table MONITOR_CACHES)

Out Of Memory Exceptions (table SYSDBA.MONITOR_OMS)

OMS Terminations (table SYSDBA.MONITOR_OMS)

Heap Usage (table OMS_HEAP_STATISTICS)

Heap Usage in KB (table OMS_HEAP_STATISTICS)

Maximum Heap Usage in KB (table ALLOCATORSTATISTICS)

System Heap in KB (table ALLOCATORSTATISTICS)

Parameter OMS_HEAP_LIMIT (KB) (dbmrfc command param_getvalue OMS_HEAP_LIMIT)

For reporting purpose , look into the following BW extractors and develop BW report.

/SAPAPO/BWEXDSRC APO -> BW: Data Source - Extractor

/SAPAPO/BWEXTRAC APO -> BW: Extractors for Transactional Data

/SAPAPO/BWEXTRFM APO -> BW: Formula to Calculate a Key Figure

/SAPAPO/BWEXTRIN APO -> BW: Dependent Extractors

/SAPAPO/BWEXTRMP APO -> BW: Mapping Extractor Structure Field

Hope this helps.

Regards,

Deepak Kori

[Former Member]

Hi Deepak,

Thank you for your reply.

The table "monitor_caches" is one of the primary table to see the various cache usages related to Livecache, but how do I see the contents of this table. I do not think this is a Oracle table. And if this is MAXDB table how can I see this table's contents.

Is there any other way may be a report which can help me get the Livecache data cache usage. Please suugest.

Regards,

Venu

[former_member188883]

Hi,

You can connect to database using SQL studio. Later you can run SQL queries like to run it for oracle database.

It should help.

Regards,

Deepak Kori

[thorsten_zielke]

Let me suggest to use the Database Analyzer data for this. Just go to transaction 'LC10 -> ...Performance -> Database Analyzer -> Expert View'. Default setting is to collect statistics every 15 minutes. The results are kept in '*.csv' files in the liveCache rundirectory. The Database Analyzer is a great tool and collects all sorts of performance data - and, yes, also cache memory statistics. So its all there, you just have to find the proper csv file and extract that data to your report.

Thorsten