Stored Procedure - Tracking Execution History

[muthuram_shanmugavel2]

Hi All,

Is there any table to track Stored Procedure execution history?

I need information that

1. Procedure name

2. Execution status

3. Procedure execution start time

4. Procedure execution end time

I checked the SYS View - "SYS"."Procedures" But i could not find these information?

P.S:

some procedure execution is going on for more than 1 hour.

We are executing these procedure from SQL editor and know the status from SQL editor console only.

Regards,

Muthuram

[pfefferf · Accepted solution]

Hello Muthuram,

to my knowledge there exists no real "tracking" feature for procedures. There exists an audit log policy type for procedure execution, but I think that is not the information you wanna see.

I think you wanna see which statement causes the long runtime. Beside the classical things like the Performance Threads view and the Trace functionality you can check system view M_ACTIVE_PROCEDURES. As long as the procedure is active it gives you detailed information about the runtime of the statements executed (or in execution) by the procedure.

Regards,

Florian

[muthuram_shanmugavel2 · Accepted solution]

Hi Florian,

Thanks for your reply.

I am using SP07 HANA System.

So "M_ACTIVE_PROCEDURE" Table is not available.

"M_ACTIVE_STATEMENTS" Table is there.

I checked this Table, My Procedure call is displayed under STATEMENT_STRING Column and STATEMENT_STATUS is shows as ACTIVE.

I think This Entry is available in the Table till Procedures execution completes.

I want the execution history of the procedures, This I could not find from this table.

Regards,

Muthuram