Performance Metric kcml.sql.fetch

Summary

Result-set fetch

Send Condition

Sent periodically during any read/write operation on an Oracle database table & KI_END or KI_CLOSE

Overview

Periodically reports on the volume of data retrieved from an Oracle database table.

Statistics

Name	Type	Description
sthandle	num	Statement handle
handle	num	Table/query handle
chandle	num	Connection handle
rows	count	Total number of rows fetched
time	usec	Total time spent fetching results
plan	num	SQL plan

General Form

kcml.sql.fetch,sthandle=num,handle=num,chandle=num,rows=count,time=usec,plan=num