本文共 11597 字,大约阅读时间需要 38 分钟。
Instance ID | : | 1 |
Session | : | xxxxxx (6839:20499) |
SQL ID | : | 9yn2xdw7uy0bq |
SQL Execution ID | : | 16777216 |
Execution Started | : | 09/17/2014 13:44:20 |
First Refresh Time | : | 09/17/2014 13:44:24 |
Last Refresh Time | : | 09/18/2014 00:05:38 |
Duration | : | 37279s |
Module/Action | : | JDBC Thin Client/- |
Service | : | xxxxxxx |
Program | : | JDBC Thin Client |
Buffer Gets | IO Requests | Database Time | Wait Activity | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|
|
|
Buffer Gets | IO Requests | Database Time | Wait Activity | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|
|
|
Id | Operation | Name | Estimated Rows | Cost | Active Period (37279s) | Execs | Rows | Memory | Temp | IO Requests | CPU Activity | Wait Activity | Progress | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
. | 0 | SELECT STATEMENT | . | . | . | . | 1 | . | . | . | | . | . | . | ||||||||||
. | 1 | . HASH UNIQUE | . | 1 | 165K |
| 1 | 0 | 610.0KB | . | | . | . | . | ||||||||||
. | 2 | .. NESTED LOOPS | . | . | . |
| 1 | 26 | . | . | | . | . | . | ||||||||||
. | 3 | ... NESTED LOOPS | . | 1 | 165K |
| 1 | 338 | . | . | | . | . | . | ||||||||||
. | 4 | .... NESTED LOOPS | . | 1 | 165K |
| 1 | 338 | . | . | | . | . | . | ||||||||||
. | 5 | ..... NESTED LOOPS | . | 1 | 165K |
| 1 | 338 | . | . | | . | . | . | ||||||||||
. | 6 | ...... NESTED LOOPS | . | 1 | 165K |
| 1 | 338 | . | . | | . | . | . | ||||||||||
. | 7 | ....... HASH JOIN | . | 1 | 165K |
| 1 | 338 | 396.0KB | . | | . | . | . | ||||||||||
. | 8 | ........ MAT_VIEW ACCESS FULL | OFFER | 1 | 48 |
| 1 | 1 | . | . | | . | . | . | ||||||||||
. | 9 | ........ NESTED LOOPS | . | . | . |
| 1 | 8M | . | . | | . | . | . | ||||||||||
. | 10 | ......... NESTED LOOPS | . | 2762 | 165K |
| 1 | 10M | . | . | | . | . | . | ||||||||||
. | 11 | .......... NESTED LOOPS | . | 482 | 164K |
| 1 | 586K | . | . | | . | . | . | ||||||||||
. | 12 | ........... NESTED LOOPS | . | 482 | 164K |
| 1 | 586K | . | . | | . | . | . | ||||||||||
-> | 13 | ............ NESTED LOOPS | . | 423 | 163K |
| 1 | 46822 | . | . | | . | . | . | ||||||||||
-> | 14 | ............. NESTED LOOPS | . | 27895 | 133K |
| 1 | 3M | . | . | | . | . | . | ||||||||||
-> | 15 | .............. TABLE ACCESS FULL | ADDRESS_NAME_LINK | 27857 | 121K |
| 1 | 5M | . | . |
|
|
|
| ||||||||||
-> | 16 | .............. INLIST ITERATOR | . | . | . |
| 5M | 3M | . | . | |
| | . | ||||||||||
-> | 17 | ............... TABLE ACCESS BY INDEX ROWID | SUBSCRIBER | 1 | 1 |
| 10M | 3M | . | . |
|
|
| . | ||||||||||
-> | 18 | ................ INDEX RANGE SCAN | SUBSCRIBER_3IX | 2 | 1 |
| 10M | 3M | . | . |
|
|
| . | ||||||||||
-> | 19 | ............. TABLE ACCESS BY INDEX ROWID | SERVICE_DETAILS | 1 | 1 |
| 3M | 46822 | . | . |
|
|
| . | ||||||||||
-> | 20 | .............. INDEX RANGE SCAN | SERVICE_DETAILS_PK | 11 | 1 |
| 3M | 47M | . | . |
|
|
| . | ||||||||||
. | 21 | ............ TABLE ACCESS BY INDEX ROWID | SERVICE_DETAILS | 1 | 1 |
| 46822 | 586K | . | . |
| . | . | . |
0 | SELECT STATEMENT | . | . | . | . | 1 | . | . | . | | . | . | . | |||||||||
. | 1 | . HASH UNIQUE | . | 1 | 165K | . | 1 | . | . | . | | . | . | . | ||||||||
. | 2 | .. NESTED LOOPS | . | . | . | . | 1 | . | . | . | | . | . | . | ||||||||
. | 3 | ... NESTED LOOPS | . | 1 | 165K | . | 1 | . | . | . | | . | . | . | ||||||||
. | 4 | .... NESTED LOOPS | . | 1 | 165K | . | 1 | . | . | . | | . | . | . | ||||||||
. | 5 | ..... NESTED LOOPS | . | 1 | 165K | . | 1 | . | . | . | | . | . | . | ||||||||
. | 6 | ...... NESTED LOOPS | . | 1 | 165K | . | 1 | . | . | . | | . | . | . | ||||||||
-> | 7 | ....... HASH JOIN | . | 1 | 165K |
| 1 | 0 | 396.0KB | . | | . | . | . | ||||||||
. | 8 | ........ MAT_VIEW ACCESS FULL | OFFER | 1 | 48 |
| 1 | 1 | . | . | | . | . | . | ||||||||
-> | 9 | ........ NESTED LOOPS | . | . | . |
| 1 | 46747 | . | . | | . | . | . | ||||||||
-> | 10 | ......... NESTED LOOPS | . | 2762 | 165K |
| 1 | 83607 | . | . | | . | . | . | ||||||||
-> | 11 | .......... NESTED LOOPS | . | 482 | 164K |
| 1 | 3357 | . | . | | . | . | . | ||||||||
-> | 12 | ........... NESTED LOOPS | . | 482 | 164K |
| 1 | 3357 | . | . | | . | . | . | ||||||||
-> | 13 | ............ NESTED LOOPS | . | 423 | 163K |
| 1 | 257 | . | . | | . | . | . | ||||||||
-> | 14 | ............. NESTED LOOPS | . | 27895 | 133K |
| 1 | 9761 | . | . | | . | . | . | ||||||||
-> | 15 | .............. TABLE ACCESS FULL | ADDRESS_NAME_LINK | 27857 | 121K |
| 1 | 19955 | . | . |
| . | . |
| ||||||||
-> | 16 | .............. INLIST ITERATOR | . | . | . |
| 19956 | 9761 | . | . | | . | . | . | ||||||||
-> | 17 | ............... TABLE ACCESS BY INDEX ROWID | SUBSCRIBER | 1 | 1 |
| 39911 | 9761 | . | . |
| |
| . | ||||||||
-> | 18 | ................ INDEX RANGE SCAN | SUBSCRIBER_3IX | 2 | 1 |
| 39911 | 9771 | . | . |
| . | . | . | ||||||||
-> | 19 | ............. TABLE ACCESS BY INDEX ROWID | SERVICE_DETAILS | 1 | 1 |
| 9762 | 257 | . | . |
| |
| . | ||||||||
-> | 20 | .............. INDEX RANGE SCAN | SERVICE_DETAILS_PK | 11 | 1 |
| 9762 | 226K | . | . |
| |
| . | ||||||||
-> | 21 | ............ TABLE ACCESS BY INDEX ROWID | SERVICE_DETAILS | 1 | 1 |
| 257 | 3357 | . | . |
| |
| . | ||||||||
-> | 22 | ............. INDEX RANGE SCAN | SERVICE_DETAILS_PK | 11 | 1 |
| 257 | 6678 | . | . | | . | . | . | ||||||||
-> | 23 | ........... TABLE ACCESS BY INDEX ROWID | CUSTOMER | 1 | 1 |
| 3357 | 3357 | . | . |
| |
| . | ||||||||
-> | 24 | ............ INDEX UNIQUE SCAN | CUSTOMER_PK | 1 | 1 |
| 3357 | 3357 | . | . |
| |
| . |
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/23718752/viewspace-1273375/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/23718752/viewspace-1273375/