Event | % Event | P1 Value, P2 Value, P3 Value | % Activity | Parameter 1 | Parameter 2 | Parameter 3 |
---|---|---|---|---|---|---|
resmgr:cpu quantum | 67.19 | "3","0","0" | 53.69 | location | ||
"2","0","0" | 13.33 | |||||
direct path read | 13.54 | "15","115072","128" | 0.02 | file number | first dba | block cnt |
read by other session | 2.06 | "15","481314","1" | 0.06 | file# | block# | class# |
db file sequential read | 1.11 | "2","114340","1" | 0.00 | file# | block# | blocks |
SQL ID | Planhash | Sampled # of Executions | % Activity | Event | % Event | Top Row Source | % RwSrc | SQL Text |
---|---|---|---|---|---|---|---|---|
fjyagwts516j8 | 1886057869 | 204 | 75.71 | resmgr:cpu quantum | 55.01 | TABLE ACCESS - FULL | 55.01 | select o.TRX_AMT as tradeAmoun... |
direct path read | 12.03 | TABLE ACCESS - FULL | 12.03 | |||||
CPU + Wait for CPU | 8.64 | TABLE ACCESS - FULL | 8.64 |