Performance Metric kcml.sql.execute

Summary

Execution of SQL plan

Send Condition

Sent when an SQL plan is executed on an Oracle database

Overview

Measures the time taken to execute an SQL query. Queries that have taken a long time to execute should be examined to see if they can be optimized. For example, ensuring they are selective and thus avoiding a full table scan by the Oracle database server.

Statistics

Name	Type	Description
schandle	num	Service context handle
sthandle	num	Statement handle
handle	num	Table/query handle
chandle	num	Connection handle
time	usec	Time taken to execute
err	num	Database error code
plan	num	SQL plan

General Form

kcml.sql.execute,schandle=num,sthandle=num,handle=num,chandle=num,time=usec,err=num,plan=num