| DB Name | DB Id | Instance | Inst num | Startup Time | Release | RAC |
|---|---|---|---|---|---|---|
| RFDWSY20 | 3943921809 | RFDWSY20 | 1 | 08-Jun-21 15:22 | 18.0.0.0.0 | NO |
| Snap Id | Snap Time | Sessions | Cursors/Session | |
|---|---|---|---|---|
| Begin Snap: | 17092 | 01-Oct-21 11:00:55 | 73 | 2.0 |
| End Snap: | 17094 | 01-Oct-21 13:00:03 | 68 | 1.9 |
| Elapsed: | 119.13 (mins) | |||
| DB Time: | 42.11 (mins) |
| SQL Id | Elapsed Time (ms) | Module | Action | SQL Text | Container DB Id |
|---|---|---|---|---|---|
| 89cf6rrncn00x | 658,808 | Module: JDBC Thin Client | SELECT ao.ASSET_ID, ao.OPERATION_ID, pu.PRODUCT_SERIAL_NUMBER, MAX(ao... | 3943921809 |
| # | Plan Hash Value | Total Elapsed Time(ms) | Executions | 1st Capture Snap ID | Last Capture Snap ID |
|---|---|---|---|---|---|
| 1 | 1768323407 | 658,808 | 4 | 17093 | 17094 |
| Stat Name | Statement Total | Per Execution | % Snap Total |
|---|---|---|---|
| Elapsed Time (ms) | 658,808 | 164,702.02 | 26.07 |
| CPU Time (ms) | 524,880 | 131,219.93 | 26.24 |
| Executions | 4 | 1.00 | 0.00 |
| Buffer Gets | 23,627,971 | 5,906,992.75 | 12.64 |
| Disk Reads | 23,740,849 | 5,935,212.25 | 26.16 |
| Parse Calls | 4 | 1.00 | 0.00 |
| Rows | 40,920,000 | 10,230,000.00 | |
| User I/O Wait Time (ms) | 137,761 | 34,440.18 | 24.85 |
| Cluster Wait Time (ms) | 0 | 0.00 | 0.00 |
| Application Wait Time (ms) | 485 | 121.36 | 23.86 |
| Concurrency Wait Time (ms) | 0 | 0.00 | 0.00 |
| Invalidations | 0 | ||
| Version Count | 2 | ||
| Sharable Mem(KB) | 191 |
| Id | Operation | Name | Rows | Bytes | TempSpc | Cost (%CPU) | Time |
|---|---|---|---|---|---|---|---|
| 0 | SELECT STATEMENT | 2868K(100) | |||||
| 1 | HASH GROUP BY | 15M | 3146M | 3317M | 2868K (1) | 00:01:53 | |
| 2 | HASH JOIN | 15M | 3146M | 1440M | 2152K (1) | 00:01:25 | |
| 3 | TABLE ACCESS FULL | FDW_R_PRODUCT_UNIT | 30M | 1088M | 308K (1) | 00:00:13 | |
| 4 | HASH JOIN | 15M | 2592M | 1573M | 1536K (1) | 00:01:01 | |
| 5 | VIEW | VW_GBC_10 | 15M | 1393M | 792K (1) | 00:00:31 | |
| 6 | TABLE ACCESS FULL | FDW_R_ASSET_OPERATION | 15M | 1618M | 792K (1) | 00:00:31 | |
| 7 | INDEX FAST FULL SCAN | FDW_REL_PRODUCT_ASSET_OPERATION_PK | 84M | 6472M | 295K (1) | 00:00:12 |