Skip to Content
avatar image
Former Member

Hana - Visual Plan - Execution Time and Memory Allocation

In Visual Plan Overview screen we can see SQL Statement Execution Time and Memory Allocation details.

Execution Time - gives the time of preparing and actually executing the query.

Memory Allocation details - Gives the dynamic memory allocation on each user.


My Question is:

Is there any table which stores this information when a SQL Statement is executed.

Or

Is there any Standard Procedures where we can pass SQL Statement to get the above information.


Thanks for your valuable help.


Thanks and Regards,

Bhaskar V

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    May 24 at 02:53 AM

    Is there any table which stores this information when a SQL Statement is executed.

    >> No, there isn't

    Is there any Standard Procedures where we can pass SQL Statement to get the above information.

    >> No, again. While PlanViz operates via a built-in internal procedure, there is no public interface or documentation available for this procedure.

    Add comment
    10|10000 characters needed characters exceeded