on 12-06-2017 2:21 PM
Hi,
I´m searching for a query which will show me the total allocated memory size for a statement after the completion of the statement, like a historical value.
I use the following query which shows me the allocated_memory_size as a snapshot during run time, but after completion the value is gone.
---------------------------------------------------------------------------------------------------------------------
select a.connection_id, a.user_name, a.application, a.applicationuser, a.workload_class_name, a.port, to_char(b.statement_string), b.allocated_memory_size, b.priority, b.statement_memory_limit, b.statement_thread_limit from sys.m_connections_ a join sys.m_prepared_statements_ b on a.connection_id = b.connection_id and a.user_name = '1_ADMIN' group by a.connection_id, a.user_name, a.application, a.applicationuser, a.workload_class_name, to_char(b.statement_string), b.allocated_memory_size, b.priority, b.statement_memory_limit, b.statement_thread_limit, a.port
---------------------------------------------------------------------------------------------------------------------
I found a lot of documentation and queries about memory consumption, but unfortunately no hints for my needs.
I´m using HANA 1.00.122.09.1493036600
Would be great to find a solution...
Many thanks
Michael
User | Count |
---|---|
93 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.