on 05-23-2018 5:16 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
76 | |
9 | |
8 | |
7 | |
6 | |
5 | |
5 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.