9 Plan hash value: 3590980838
10
11 -----------------------------------------------------------------------------------------------------------------------------------------------------------
12 | Id | Operation | Name | E-Rows |E-Bytes| Cost (%CPU)| E-Time | Pstart| Pstop | OMem | 1Mem | Used-Mem |
13 -----------------------------------------------------------------------------------------------------------------------------------------------------------
14 | 0 | SELECT STATEMENT | | | | 10 (100)| | | | | | |
15 | 1 | SORT AGGREGATE | | 1 | | | | | | | | |
16 | 2 | VIEW | VM_NWVW_0 | 2 | | 10 (10)| 00:00:01 | | | | | |
17 | 3 | HASH GROUP BY | | 2 | 388 | 10 (10)| 00:00:01 | | | 788K| 788K| |
18 | 4 | NESTED LOOPS | | 2 | 388 | 9 (0)| 00:00:01 | | | | | |
19 | 5 | NESTED LOOPS | | 2 | 388 | 9 (0)| 00:00:01 | | | | | |
20 |* 6 | TABLE ACCESS BY GLOBAL INDEX ROWID| CCPS_CREDITINFO | 2 | 300 | 6 (0)| 00:00:01 | ROWID | ROWID | | | |
21 |* 7 | INDEX RANGE SCAN | IX_CI_EMAIL | 2 | | 3 (0)| 00:00:01 | | | | | |
22 |* 8 | INDEX UNIQUE SCAN | PK_CCPS_TRADERECORD | 1 | | 1 (0)| 00:00:01 | | | | | |
23 |* 9 | TABLE ACCESS BY GLOBAL INDEX ROWID | CCPS_TRADERECORD | 1 | 44 | 2 (0)| 00:00:01 | ROWID | ROWID | | | |
24 -----------------------------------------------------------------------------------------------------------------------------------------------------------
25
26 Query Block Name / Object Alias (identified by operation id):
27 -------------------------------------------------------------
28
29 1 - SEL$DD8D4BD4
30 2 - SEL$3DD9CB74 / VM_NWVW_0@SEL$DD8D4BD4
31 3 - SEL$3DD9CB74
32 6 - SEL$3DD9CB74 / CC@SEL$2
33 7 - SEL$3DD9CB74 / CC@SEL$2
34 8 - SEL$3DD9CB74 / T@SEL$2
35 9 - SEL$3DD9CB74 / T@SEL$2
36
37 Peeked Binds (identified by position):
38 --------------------------------------
39
40 1 - (NUMBER): 720
41 2 - (VARCHAR2(30), CSID=873): '170655'
42 3 - (VARCHAR2(30), CSID=873): '1633660361@bigo.tv'
43 4 - (VARCHAR2(30), CSID=873): '0a43f0c85b9106b65204ee6ec3ccec198aa297b0d8c80388dab8eb3c3067844776b70a82bd862a80ccf1cc658502f8367d2030d2c502869f4a26a496
44 fd14e8e3966616a98853764be00cfff364c1d41a'
45
46 Predicate Information (identified by operation id):
47 ---------------------------------------------------
48
49 6 - filter("CC"."CI_SHA256"<>SYS_OP_C2C(:4))
50 7 - access("CC"."CI_EMAIL"=SYS_OP_C2C(:3))
51 8 - access("T"."TR_NO"="CC"."CI_TR_NO")
52 9 - filter(("T"."TR_MER_NO"=TO_NUMBER(:2) AND "T"."TR_PM_ID"=1 AND "T"."TR_IS_REPAY"<=1 AND "T"."TR_DATETIME">=SYSDATE@!-:1/24))
53
54 Note
55 -----
56 - Warning: basic plan statistics not available. These are only collected when:
57 * hint 'gather_plan_statistics' is used for the statement or
58 * parameter 'statistics_level' is set to 'ALL', at session or system level
59
转播
