Skip to Content

Oracle Database Monitoring – Introduction of LSSM

As described in SAP notes 1314689 and 1299493 a new functionality that was until recently only internally used by SAP Support was integrated into dbacockpit for Oracle: LSSM (Loadable SAP Support Monitors).

In short, the huge advantage of this functionality is, that the monitor definitions are decoupled from your basis support packages, since their logic is delivered via small files that you download to your workstation and afterwards upload in dbacockpit. The configuration is very simple and involves the following steps:

Afterwards, the monitor set can be launched and we see the following:

The logic behind this tree structure is quite simple. Lines that are light blue can not be executed, they are just used for structuring the tree.

The other lines in dark blue are for executing the assigned monitor:

You also have the possibility to just copy the SQL statement generated by this monitor into the clipboard respectivly directly transfer the result to excel.

Finally, I will show some of the monitors I am using on a regular basis and the information we can get out of them (I am just showing the fancy excel charts, usually, I am working with the raw data).

DB Time Overview (by class) -> DB Time History

DB Time Overview (by class) -> DB Time (by event) -> db file sequential read -> Histogram db file seq. read

Here we can see that the majority of the total (sequential) read time is consumed by those reads that are taking between 4 and 16 ms (which is quite ok).

DB Time Overview (by class) -> DB Time (by event) -> CPU time -> Top Seg. logical reads

Of course, there are many other useful monitors. I would suggest to play around with them and see what data you get.

Be the first to leave a comment
You must be Logged on to comment or reply to a post.