| |
<SQLTimeByRequestLocation> |
| Name |
<LocationName>location</LocationName> |
| Nbr of SQL Calls |
<NumberOfCalls>n</NumberOfCalls> |
| --CPU Time -- Total |
<TotalCPUTime>n</TotalCPUTime> |
| --CPU Time-- Mean |
<MeanCPUTime>n</MeanCPUTime> |
| --CPU Time-- Pct |
<PctCPUTime>n</PctCPUTime> |
| --Svc Time-- Total |
<TotalServiceTime>n</TotalServiceTime> |
| --Svc Time-- Mean |
<MeanServiceTime>n</MeanServiceTime> |
| --Svc Time-- Pct |
<PctServiceTime>n</PctServiceTime> |
| |
<GetPagesIdx>n</GetPagesIdx> |
| |
<GetPages>n</GetPages> |
| |
<SyncReadIO>n</SyncReadIO> |
| |
<PrefetchReq>n</PrefetchReq> |
| |
<SyncWriteIO>n</SyncWriteIO> |
| |
<SQLTimeByStatement> |
| Name |
<SequenceNumber>seqno</SequenceNumber> |
| Plan/Pgm |
<PlanName>name</PlanName> |
| Stmt# |
<StatementNumber>n</StatementNumber> |
| SQL Function |
<SQLFunction>function</SQLFunction> |
| Nbr of SQL Calls |
<NumberOfCalls>n</NumberOfCalls> |
| --CPU Time -- Total |
<TotalCPUTime>n</TotalCPUTime> |
| --CPU Time-- Mean |
<MeanCPUTime>n</MeanCPUTime> |
| --CPU Time-- Pct |
<PctCPUTime>n</PctCPUTime> |
| --Svc Time-- Total |
<TotalServiceTime>n</TotalServiceTime> |
| --Svc Time-- Mean |
<MeanServiceTime>n</MeanServiceTime> |
| --Svc Time-- Pct |
<PctServiceTime>n</PctServiceTime> |
| |
<SQLTextLines> |
| |
<SQLTEXT>sqltext</SQLTEXT> |
| |
<PrepareInfo> |
| |
<PrepareStatementNumber>n</PrepareStatementNumber> |
| |
<PrepareSequenceNumber>seqno</PrepareSequenceNumber> |
| |
</PrepareInfo> |
| |
</SQLTextLines> |
| |
</SQLTimeByStatement> |
| |
</SQLTimeByRequestLocation> |