Skip to Content
0
Oct 11, 2017 at 08:30 PM

SAP HANA : How to determine how much memory a user is using ?

240 Views Last edit Oct 12, 2017 at 05:20 AM 2 rev

Hello,

We are using SAP HANA 1.0 SPS12. We have created one dedicated user for each application. Some of our applications are very memory consumming.

We would like to know how to check which user are using more memory ?

How to determine how much memory a user is using ?

I have found a SQL query for Oracle Database : https://community.oracle.com/thread/938686 and I have also checked "SQL Statement Collection for SAP HANA" but "HANA_Memory_TopConsumers_1.00.85+" query didn't provided the username.

Is there a SQL query to do that ?

I would like to avoid traces for the moment.

Thank you !