| DB Name | DB Id | Instance | Inst num | Release | RAC | Host |
|---|---|---|---|---|---|---|
| C1DB0318 | 3371234238 | c1db0318 | 1 | 10.2.0.5.0 | NO | c1db0318 |
| Snap Id | Snap Time | Sessions | Cursors/Session | |
|---|---|---|---|---|
| Begin Snap: | 5032 | 19-Aug-14 07:00:59 | 2189 | 27.6 |
| End Snap: | 5033 | 19-Aug-14 08:00:43 | 2186 | 26.9 |
| Elapsed: | 59.73 (mins) | |||
| DB Time: | 51,071.84 (mins) |
| SQL Id | Elapsed Time (ms) | Module | Action | SQL Text |
|---|---|---|---|---|
| 9hfkh0vxd9wq0 | 2,232,532,345 | YB_UnicomCzA93.exe | SELECT HF_SERIALID FROM (SELECT HF_SERIALID FROM CH_FULLNOTE WHERE BEG... |
| # | Plan Hash Value | Total Elapsed Time(ms) | Executions | 1st Capture Snap ID | Last Capture Snap ID |
|---|---|---|---|---|---|
| 1 | 1655445474 | 2,232,532,345 | 393,955 | 5033 | 5033 |
| Stat Name | Statement Total | Per Execution | % Snap Total |
|---|---|---|---|
| Elapsed Time (ms) | 2,232,532,345 | 5,666.97 | 72.86 |
| CPU Time (ms) | 5,394,563 | 13.69 | 34.27 |
| Executions | 393,955 | ||
| Buffer Gets | 133,671,121 | 339.31 | 68.66 |
| Disk Reads | 0 | 0.00 | 0.00 |
| Parse Calls | 1 | 0.00 | 0.00 |
| Rows | 2,226 | 0.01 | |
| User I/O Wait Time (ms) | 0 | ||
| Cluster Wait Time (ms) | 0 | ||
| Application Wait Time (ms) | 0 | ||
| Concurrency Wait Time (ms) | 2,078,328,411 | ||
| Invalidations | 0 | ||
| Version Count | 3 | ||
| Sharable Mem(KB) | 135 |
| Id | Operation | Name | Rows | Bytes | Cost (%CPU) | Time |
|---|---|---|---|---|---|---|
| 0 | SELECT STATEMENT | 27 (100) | ||||
| 1 | COUNT STOPKEY | |||||
| 2 | VIEW | 1 | 17 | 27 (8) | 00:00:01 | |
| 3 | SORT ORDER BY STOPKEY | 1 | 42 | 27 (8) | 00:00:01 | |
| 4 | HASH JOIN SEMI | 1 | 42 | 26 (4) | 00:00:01 | |
| 5 | TABLE ACCESS BY INDEX ROWID | CH_FULLNOTE | 1 | 40 | 1 (0) | 00:00:01 |
| 6 | INDEX RANGE SCAN | IND_CH_FULLNOTE_BEGINTIME | 4 | 1 (0) | 00:00:01 | |
| 7 | COLLECTION ITERATOR PICKLER FETCH | FUN_SPLIT_STR_TO_TABLE |