Performance Metric kcml.sql.total
Summary
Total remote database loadSend Condition
Program LOAD, SOAP server method calls, form events & $END. Periodically from database or native file I/O operations, $BREAK, $IF & 'KCML_poll()Overview
Periodically reports the amount of load on an Oracle database. The kcml.sql.prepare, kcml.sql.execute, kcml.sql.fetch & kcml.sql.lobread metrics can be used to identify which SQL queries are the most expensive to service.Statistics
| Name | Type | Description |
|---|---|---|
| prepcnt | num | Number of SQL plans that have been prepared |
| execcnt | num | Number of SQL plans that have been executed |
| fetchcnt | num | Number of fetch operations |
| lobrds | num | LOB read count |
| ptime | usec | Total time spent preparing SQL plans |
| etime | usec | Total time spent executing SQL plans |
| ftime | usec | Total time spent fetching results |
| ltime | usec | Total time spent reading & writing LOBs |
| hdlcnt | num | Number of active (non-deferred) handles |
| curscnt | num | Number of active cursors |
General Form
kcml.sql.total,prepcnt=num,execcnt=num,fetchcnt=num,lobrds=num,ptime=usec,etime=usec,ftime=usec,ltime=usec,hdlcnt=num,curscnt=numSee Also:
Performance Metrics