Skip to Content
avatar image
Former Member

How to find allocated memory size for a statement after completion

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers