License : "N" SQL_ID : "1j6n5gtxd19y2" RDBMS : "10.2.0.1.0" Platform: "LINUX" OFE : "10.2.0.1" DYN_SAMP: "4" EBS: "" SIEBEL : "" PSFT : "" Date : "2012-05-11/17:15:06"
| # | Type | Name | Observation | More |
|---|---|---|---|---|
| 1 | CBO PARAMETER | DB_FILE_MULTIBLOCK_READ_COUNT | MBRC Parameter is set to "16" overriding its default value. | The default value of this parameter is a value that corresponds to the maximum I/O size that can be performed efficiently. This value is platform-dependent and is 1MB for most platforms. Because the parameter is expressed in blocks, it will be set to a value that is equal to the maximum I/O size that can be performed efficiently divided by the standard block size. |
| 2 | CBO PARAMETER | OPTIMIZER_DYNAMIC_SAMPLING | CBO initialization parameter "optimizer_dynamic_sampling" with a non-default value of "4" as per V$SQL_OPTIMIZER_ENV. | Review the correctness of this non-default value "4" for SQL_ID 1j6n5gtxd19y2. |
| 3 | CBO PARAMETER | OPTIMIZER_INDEX_COST_ADJ | CBO initialization parameter "optimizer_index_cost_adj" with a non-default value of "40" as per V$SQL_OPTIMIZER_ENV. | Review the correctness of this non-default value "40" for SQL_ID 1j6n5gtxd19y2. |
| 4 | CBO PARAMETER | _PGA_MAX_SIZE | CBO initialization parameter "_pga_max_size" with a non-default value of "524280 KB" as per V$SQL_OPTIMIZER_ENV. | Review the correctness of this non-default value "524280 KB" for SQL_ID 1j6n5gtxd19y2. |
| 5 | DBMS_STATS | SYSTEM STATISTICS | Workload CBO System Statistics are not gathered. CBO is using default values. | Consider gathering workload system statistics using DBMS_STATS.GATHER_SYSTEM_STATS. See also 465787.1. |
| 6 | TABLE | NC152.ARAP_DJFB | Sample size of 29322 rows may be too small for table with 586440 rows. | Sample percent used was:5.00%. Consider gathering better quality table statistics with a sample size of 100%. |
| 7 | TABLE | NC152.ARAP_DJFB | Contains 32 column(s) with missing CBO statistics. | Consider gathering table statistics using DBMS_STATS.GATHER_TABLE_STATS. See 465787.1. |
| 8 | TABLE | NC152.ARAP_DJFB | Table contains column(s) with outdated CBO statistics for up to 1575 day(s). | CBO table and column statistics are inconsistent. Consider gathering statistics for this table. Old statistics could contain low/high values for which a predicate may be out of range, producing then a poor plan. |
| 9 | TABLE | NC152.ARAP_DJFB | Number of distinct values is zero in at least 137 column(s) with value. | There should not be columns with value ((num_rows - num_nulls) greater than 0) where the number of distinct values for the same column is zero. Worst column shows 586440 rows with value while the number of distinct values for it is zero. CBO table and column statistics are inconsistent. Consider gathering statistics for this table using a large sample size. |
| 10 | TABLE | NC152.ARAP_DJFB | Table contains 2 column(s) where the number of buckets is 1 for a "FREQUENCY" histogram. | Review column statistics for this table and look for "Num Buckets" and "Histogram". Possible Bugs 1386119, 4406309, 4495422, 4567767, 5483301 or 6082745. If you are referencing in your predicates one of the missing values the CBO can over estimate table cardinality, and this may produce a sub-optimal plan. You can either gather statistics with 100% or as a workaround: ALTER system/session "_fix_control"='5483301:OFF'; |
| 11 | TABLE | NC152.ARAP_DJLX | Contains 4 column(s) with missing CBO statistics. | Consider gathering table statistics using DBMS_STATS.GATHER_TABLE_STATS. See 465787.1. |
| 12 | TABLE | NC152.ARAP_DJLX | Table contains column(s) with outdated CBO statistics for up to 1575 day(s). | CBO table and column statistics are inconsistent. Consider gathering statistics for this table. Old statistics could contain low/high values for which a predicate may be out of range, producing then a poor plan. |
| 13 | TABLE | NC152.ARAP_DJLX | Number of distinct values is zero in at least 1 column(s) with value. | There should not be columns with value ((num_rows - num_nulls) greater than 0) where the number of distinct values for the same column is zero. Worst column shows 178 rows with value while the number of distinct values for it is zero. CBO table and column statistics are inconsistent. Consider gathering statistics for this table using a large sample size. |
| 14 | TABLE | NC152.ARAP_DJZB | Sample size of 14181 rows may be too small for table with 283620 rows. | Sample percent used was:5.00%. Consider gathering better quality table statistics with a sample size of 100%. |
| 15 | TABLE | NC152.ARAP_DJZB | Contains 19 column(s) with missing CBO statistics. | Consider gathering table statistics using DBMS_STATS.GATHER_TABLE_STATS. See 465787.1. |
| 16 | TABLE | NC152.ARAP_DJZB | Table contains column(s) with outdated CBO statistics for up to 1575 day(s). | CBO table and column statistics are inconsistent. Consider gathering statistics for this table. Old statistics could contain low/high values for which a predicate may be out of range, producing then a poor plan. |
| 17 | TABLE | NC152.ARAP_DJZB | Number of distinct values is zero in at least 66 column(s) with value. | There should not be columns with value ((num_rows - num_nulls) greater than 0) where the number of distinct values for the same column is zero. Worst column shows 283620 rows with value while the number of distinct values for it is zero. CBO table and column statistics are inconsistent. Consider gathering statistics for this table using a large sample size. |
| 18 | TABLE | NC152.BD_ACCBANK | Contains 3 column(s) with missing CBO statistics. | Consider gathering table statistics using DBMS_STATS.GATHER_TABLE_STATS. See 465787.1. |
| 19 | TABLE | NC152.BD_ACCBANK | Table contains column(s) with outdated CBO statistics for up to 1575 day(s). | CBO table and column statistics are inconsistent. Consider gathering statistics for this table. Old statistics could contain low/high values for which a predicate may be out of range, producing then a poor plan. |
| 20 | TABLE | NC152.BD_ACCBANK | Number of distinct values is zero in at least 23 column(s) with value. | There should not be columns with value ((num_rows - num_nulls) greater than 0) where the number of distinct values for the same column is zero. Worst column shows 4587 rows with value while the number of distinct values for it is zero. CBO table and column statistics are inconsistent. Consider gathering statistics for this table using a large sample size. |
| 21 | TABLE | NC152.BD_ACCID | Table contains column(s) with outdated CBO statistics for up to 1575 day(s). | CBO table and column statistics are inconsistent. Consider gathering statistics for this table. Old statistics could contain low/high values for which a predicate may be out of range, producing then a poor plan. |
| 22 | TABLE | NC152.BD_ACCID | Number of distinct values is zero in at least 37 column(s) with value. | There should not be columns with value ((num_rows - num_nulls) greater than 0) where the number of distinct values for the same column is zero. Worst column shows 2224 rows with value while the number of distinct values for it is zero. CBO table and column statistics are inconsistent. Consider gathering statistics for this table using a large sample size. |
| 23 | TABLE | NC152.BD_CORP | Table contains column(s) with outdated CBO statistics for up to 1575 day(s). | CBO table and column statistics are inconsistent. Consider gathering statistics for this table. Old statistics could contain low/high values for which a predicate may be out of range, producing then a poor plan. |
| 24 | TABLE | NC152.BD_CORP | Number of distinct values is zero in at least 50 column(s) with value. | There should not be columns with value ((num_rows - num_nulls) greater than 0) where the number of distinct values for the same column is zero. Worst column shows 92 rows with value while the number of distinct values for it is zero. CBO table and column statistics are inconsistent. Consider gathering statistics for this table using a large sample size. |
| 25 | TABLE | NC152.BD_COSTSUBJ | Contains 1 column(s) with missing CBO statistics. | Consider gathering table statistics using DBMS_STATS.GATHER_TABLE_STATS. See 465787.1. |
| 26 | TABLE | NC152.BD_COSTSUBJ | Table contains column(s) with outdated CBO statistics for up to 1575 day(s). | CBO table and column statistics are inconsistent. Consider gathering statistics for this table. Old statistics could contain low/high values for which a predicate may be out of range, producing then a poor plan. |
| 27 | TABLE | NC152.BD_COSTSUBJ | Number of distinct values is zero in at least 29 column(s) with value. | There should not be columns with value ((num_rows - num_nulls) greater than 0) where the number of distinct values for the same column is zero. Worst column shows 2472 rows with value while the number of distinct values for it is zero. CBO table and column statistics are inconsistent. Consider gathering statistics for this table using a large sample size. |
| 28 | TABLE | NC152.BD_DEFDOC | Sample size of 16182 rows may be too small for table with 32364 rows. | Sample percent used was:50.00%. Consider gathering better quality table statistics with a sample size of 100%. |
| 29 | TABLE | NC152.BD_DEFDOC | Table contains column(s) with outdated CBO statistics for up to 1575 day(s). | CBO table and column statistics are inconsistent. Consider gathering statistics for this table. Old statistics could contain low/high values for which a predicate may be out of range, producing then a poor plan. |
| 30 | 1-COL INDEX | I_ARAP_DJFB007(DDLX) | Number of distinct values (17268) does not match number of distinct keys (65821) by 281%. | Possible Bug 4495422 or 9885553. This is an inconsistency on this indexed column. Gather fresh statistics with no histograms or adjusting DISTCNT and DENSITY using SET_COLUMN_statistics APIs. |
| 31 | 1-COL INDEX | I_ARAP_DJFB009(KMBM) | Number of distinct values (500) does not match number of distinct keys (1158) by 132%. | Possible Bug 4495422 or 9885553. This is an inconsistency on this indexed column. Gather fresh statistics with no histograms or adjusting DISTCNT and DENSITY using SET_COLUMN_statistics APIs. |
| 32 | 1-COL INDEX | I_ARAP_DJZB001(DJRQ) | Number of distinct values (1015) does not match number of distinct keys (1209) by 19%. | Possible Bug 4495422 or 9885553. This is an inconsistency on this indexed column. Gather fresh statistics with no histograms or adjusting DISTCNT and DENSITY using SET_COLUMN_statistics APIs. |
| 33 | 1-COL INDEX | I_BD_DEFDOC(PK_CORP) | Number of distinct values (3) does not match number of distinct keys (4) by 33%. | Possible Bug 4495422 or 9885553. This is an inconsistency on this indexed column. Gather fresh statistics with no histograms or adjusting DISTCNT and DENSITY using SET_COLUMN_statistics APIs. |
select case when a.corpareacode = '04' then '0401' when a.corpareacode = '05' then '0402' else a.corpareacode || '00' end || xmcode corpareacode, a.corpareaname, a.unitname, a.bankname, a.bankacc, a.xmname, nvl ( a.beginbmny, 0 ) + nvl ( bbje, 0 ) hjmny, case when substr ( a.acode, 0, 1 ) = '1' then '可动用资金' end kyaname, case when substr ( a.acode, 0, 1 ) = '1' then nvl ( a.beginbmny, 0 ) + nvl ( bbje, 0 ) end kymnyb, case when substr ( a.acode, 0, 1 ) = '2' then nvl ( a.beginbmny, 0 ) + nvl ( bbje, 0 ) end hjsxmnyb, case when substr ( a.acode, 0, 1 ) = '2' then a.aname else '监控户' end sxaname, case when substr ( a.acode, 0, 1 ) = '2' then nvl ( a.beginbmny, 0 ) + nvl ( bbje, 0 ) else 0 end sxmnyb from v_accid_beginmny a, ( select accid.pk_accid pk_accid, sum ( nvl ( arap.jfbbje, 0 ) ) - sum ( nvl ( arap.dfbbje, 0 ) ) bbje, sum ( nvl ( arap.jfybje, 0 ) ) - sum ( nvl ( arap.dfybje, 0 ) ) ybje from bd_accid accid, v_arap_detail arap where accid.pk_accid = arap.accountid and ( 1 = 1 and arap.djrq <= '2012-05-11' ) group by accid.pk_accid ) b where a.pk_accid = b.pk_accid ( + ) and ( a.acode is not null and nvl ( a.beginbmny, 0 ) + nvl ( bbje, 0 ) <> 0 and a.pk_defdoc = '0001V5100000000CABMI' ) order by a.corpareacode, a.xmname
| # | Table Name | Owner | Num Rows | Table Sample Size |
Last Analyzed | Indexes | Avg Index Sample Size |
Table Columns |
Columns with Histogram |
Avg Column Sample Size |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | ARAP_DJFB | NC152 | 586440 | 29322 | 11-5月 -12 02:00:49 | 13 | 189329 | 189 | 15 | 21630 |
| 2 | ARAP_DJLX | NC152 | 195 | 195 | 11-5月 -12 02:01:29 | 2 | 195 | 25 | 3 | 195 |
| 3 | ARAP_DJZB | NC152 | 283620 | 14181 | 11-5月 -12 02:01:30 | 7 | 198044 | 97 | 9 | 14377 |
| 4 | BD_ACCBANK | NC152 | 4617 | 4617 | 11-5月 -12 02:01:58 | 2 | 4617 | 47 | 3 | 4617 |
| 5 | BD_ACCID | NC152 | 2225 | 2225 | 11-5月 -12 02:01:59 | 2 | 2225 | 62 | 3 | 2225 |
| 6 | BD_CORP | NC152 | 587 | 587 | 11-5月 -12 02:02:47 | 3 | 587 | 73 | 3 | 587 |
| 7 | BD_COSTSUBJ | NC152 | 2472 | 2472 | 11-5月 -12 02:02:49 | 2 | 2472 | 33 | 3 | 2472 |
| 8 | BD_DEFDOC | NC152 | 32364 | 16182 | 11-5月 -12 02:03:34 | 4 | 32497 | 10 | 4 | 16222 |
| # | Table Name | Table Owner |
Index Name | Index Owner |
In MEM Plan |
In AWR Plan |
Num Rows | Index Sample Size |
Last Analyzed | Index Columns |
Columns with Histogram |
Avg Column Sample Size |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | ARAP_DJFB | NC152 | IX_ARAP_DJFB_FO_DR | NC152 | 579573 | 217151 | 11-5月 -12 02:00:51 | 2 | 2 | 29322 | ||
| 2 | ARAP_DJFB | NC152 | I_ARAP_DJFB001 | NC152 | 572210 | 219548 | 11-5月 -12 02:00:58 | 1 | 1 | 29322 | ||
| 3 | ARAP_DJFB | NC152 | I_ARAP_DJFB002 | NC152 | 237338 | 194744 | 11-5月 -12 02:00:59 | 1 | 1 | 11846 | ||
| 4 | ARAP_DJFB | NC152 | I_ARAP_DJFB003 | NC152 | 555633 | 200592 | 11-5月 -12 02:01:01 | 1 | 1 | 28098 | ||
| 5 | ARAP_DJFB | NC152 | I_ARAP_DJFB004 | NC152 | 415130 | 208063 | 11-5月 -12 02:01:02 | 1 | 1 | 20474 | ||
| 6 | ARAP_DJFB | NC152 | I_ARAP_DJFB005 | NC152 | 545938 | 209748 | 11-5月 -12 02:01:04 | 1 | 1 | 27147 | ||
| 7 | ARAP_DJFB | NC152 | I_ARAP_DJFB006 | NC152 | 548317 | 51381 | 11-5月 -12 02:01:07 | 6 | 6 | 22611 | ||
| 8 | ARAP_DJFB | NC152 | I_ARAP_DJFB007 | NC152 | 162044 | 162044 | 11-5月 -12 02:01:09 | 1 | 1 | 8262 | ||
| 9 | ARAP_DJFB | NC152 | I_ARAP_DJFB008 | NC152 | 236 | 236 | 11-5月 -12 02:00:53 | 1 | 0 | 236 | ||
| 10 | ARAP_DJFB | NC152 | I_ARAP_DJFB009 | NC152 | 160695 | 160695 | 11-5月 -12 02:01:11 | 1 | 1 | 8115 | ||
| 11 | ARAP_DJFB | NC152 | I_ARAP_DJFB010 | NC152 | 584063 | 219693 | 11-5月 -12 02:01:13 | 6 | 2 | 29322 | ||
| 12 | ARAP_DJFB | NC152 | I_ARAP_DJFB_009 | NC152 | 569053 | 410615 | 11-5月 -12 02:00:56 | 2 | 2 | 23591 | ||
| 13 | ARAP_DJFB | NC152 | PK_ARAP_DJFB | NC152 | 572730 | 206764 | 11-5月 -12 02:00:53 | 1 | 1 | 29322 | ||
| 14 | ARAP_DJLX | NC152 | IARAP_DJLX001 | NC152 | 195 | 195 | 11-5月 -12 02:01:29 | 2 | 2 | 195 | ||
| 15 | ARAP_DJLX | NC152 | PK_ARAP_DJLX | NC152 | 195 | 195 | 11-5月 -12 02:01:29 | 1 | 1 | 195 | ||
| 16 | ARAP_DJZB | NC152 | IDX$$_1FC500001 | NC152 | 291181 | 261324 | 11-5月 -12 02:01:33 | 4 | 4 | 14181 | ||
| 17 | ARAP_DJZB | NC152 | I_ARAP_DJZB001 | NC152 | 285096 | 285096 | 11-5月 -12 02:01:37 | 1 | 1 | 14181 | ||
| 18 | ARAP_DJZB | NC152 | I_ARAP_DJZB002 | NC152 | 285096 | 285096 | 11-5月 -12 02:01:40 | 2 | 2 | 14181 | ||
| 19 | ARAP_DJZB | NC152 | I_ARAP_DJZB_003 | NC152 | 283015 | 121583 | 11-5月 -12 02:01:41 | 6 | 4 | 14181 | ||
| 20 | ARAP_DJZB | NC152 | I_ARAP_DJZB_004 | NC152 | 283305 | 196526 | 11-5月 -12 02:01:42 | 1 | 1 | 14181 | ||
| 21 | ARAP_DJZB | NC152 | I_ARAP_DJZB_005 | NC152 | 24953 | 24953 | 11-5月 -12 02:01:43 | 1 | 0 | 24949 | ||
| 22 | ARAP_DJZB | NC152 | PK_ARAP_DJZB | NC152 | 281998 | 211729 | 11-5月 -12 02:01:34 | 1 | 0 | 14181 | ||
| 23 | BD_ACCBANK | NC152 | I_BD_ACCBANK_1 | NC152 | 4617 | 4617 | 11-5月 -12 02:01:59 | 2 | 2 | 4617 | ||
| 24 | BD_ACCBANK | NC152 | PK_BD_ACCBANK | NC152 | YES | 4617 | 4617 | 11-5月 -12 02:01:58 | 1 | 1 | 4617 | |
| 25 | BD_ACCID | NC152 | I_BD_ACCID_1 | NC152 | 2225 | 2225 | 11-5月 -12 02:02:00 | 2 | 2 | 2225 | ||
| 26 | BD_ACCID | NC152 | PK_BD_ACCID | NC152 | YES | 2225 | 2225 | 11-5月 -12 02:01:59 | 1 | 1 | 2225 | |
| 27 | BD_CORP | NC152 | I_BD_CORP_1 | NC152 | 587 | 587 | 11-5月 -12 02:02:47 | 1 | 1 | 587 | ||
| 28 | BD_CORP | NC152 | I_BD_CORP_2 | NC152 | 587 | 587 | 11-5月 -12 02:02:47 | 1 | 1 | 587 | ||
| 29 | BD_CORP | NC152 | PK_BD_CORP | NC152 | YES | 587 | 587 | 11-5月 -12 02:02:47 | 1 | 1 | 587 | |
| 30 | BD_COSTSUBJ | NC152 | I_BD_COSTSUBJ_1 | NC152 | 2472 | 2472 | 11-5月 -12 02:02:49 | 2 | 2 | 2472 | ||
| 31 | BD_COSTSUBJ | NC152 | PK_BD_COSTSUBJ | NC152 | 2472 | 2472 | 11-5月 -12 02:02:49 | 1 | 1 | 2472 | ||
| 32 | BD_DEFDOC | NC152 | I_BD_DEFDOC | NC152 | 32497 | 32497 | 11-5月 -12 02:03:34 | 1 | 1 | 16267 | ||
| 33 | BD_DEFDOC | NC152 | I_BD_DEFDOC_1 | NC152 | 32497 | 32497 | 11-5月 -12 02:03:34 | 3 | 3 | 16218 | ||
| 34 | BD_DEFDOC | NC152 | I_BD_DEFDOC_2 | NC152 | 32497 | 32497 | 11-5月 -12 02:03:34 | 1 | 1 | 16354 | ||
| 35 | BD_DEFDOC | NC152 | PK_BD_DEFDOC | NC152 | YES | 32497 | 32497 | 11-5月 -12 02:03:34 | 1 | 1 | 16235 |
| # | Inst ID |
Child Num |
Plan HV | Execs | Fetch | Loads | Inval | Parse Calls |
Buffer Gets |
Disk Reads |
Direct Writes |
Rows Proc |
Elapsed Time (secs) |
CPU Time (secs) |
IO Time (secs) |
Conc Time (secs) |
Appl Time (secs) |
Clus Time (secs) |
PLSQL Time (secs) |
Java Time (secs) |
Optimizer Mode |
Cost | Opt Env HV | Parsing Schema Name |
Module | Action | Outline | Profile | First Load | Last Load | Last Active |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1 | 0 | 580003853 | 2 | 30 | 2 | 0 | 2 | 9858821 | 22697 | 22695 | 284 | 42.420 | 36.425 | 0.800 | 0.001 | 0.000 | 5.478 | 0.000 | 0.000 | ALL_ROWS | 53233 | 6024297 | NC152 | 2012-05-11/16:23:09 | 2012-05-11/16:52:53 | 2012-05-11/17:00:00 |
| # | Snap ID |
Snaphot | Inst ID |
Plan HV | Vers Cnt |
Execs | Fetch | Loads | Inval | Parse Calls |
Buffer Gets |
Disk Reads |
Direct Writes |
Rows Proc |
Elapsed Time (secs) |
CPU Time (secs) |
IO Time (secs) |
Conc Time (secs) |
Appl Time (secs) |
Clus Time (secs) |
PLSQL Time (secs) |
Java Time (secs) |
Optimizer Mode |
Cost | Opt Env HV | Parsing Schema Name |
Module | Action | Profile |
|---|
Inst: 1 Child: 0 Plan hash value: 580003853
------------------------------------------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | E-Rows |E-Bytes|E-Temp | Cost (%CPU)| E-Time | OMem | 1Mem | Used-Mem |
------------------------------------------------------------------------------------------------------------------------------------------------
| 1 | SORT ORDER BY | | 1 | 358 | | 53233 (1)| 00:10:39 | 27648 | 27648 |24576 (0)|
|* 2 | FILTER | | | | | | | | | |
|* 3 | HASH JOIN OUTER | | 1 | 358 | | 53232 (1)| 00:10:39 | 737K| 737K| 1276K (0)|
| 4 | NESTED LOOPS OUTER | | 1 | 324 | | 27 (0)| 00:00:01 | | | |
| 5 | NESTED LOOPS OUTER | | 1 | 293 | | 26 (0)| 00:00:01 | | | |
| 6 | NESTED LOOPS OUTER | | 1 | 227 | | 25 (0)| 00:00:01 | | | |
| 7 | NESTED LOOPS | | 1 | 164 | | 24 (0)| 00:00:01 | | | |
| 8 | NESTED LOOPS | | 362 | 35476 | | 23 (0)| 00:00:01 | | | |
| 9 | TABLE ACCESS BY INDEX ROWID | BD_DEFDOC | 1 | 66 | | 1 (0)| 00:00:01 | | | |
|* 10 | INDEX UNIQUE SCAN | PK_BD_DEFDOC | 1 | | | 1 (0)| 00:00:01 | | | |
|* 11 | TABLE ACCESS FULL | BD_ACCID | 362 | 11584 | | 22 (0)| 00:00:01 | | | |
| 12 | TABLE ACCESS BY INDEX ROWID | BD_DEFDOC | 1 | 66 | | 1 (0)| 00:00:01 | | | |
|* 13 | INDEX UNIQUE SCAN | PK_BD_DEFDOC | 1 | | | 1 (0)| 00:00:01 | | | |
| 14 | TABLE ACCESS BY INDEX ROWID | BD_ACCBANK | 1 | 63 | | 1 (0)| 00:00:01 | | | |
|* 15 | INDEX UNIQUE SCAN | PK_BD_ACCBANK | 1 | | | 1 (0)| 00:00:01 | | | |
| 16 | TABLE ACCESS BY INDEX ROWID | BD_DEFDOC | 1 | 66 | | 1 (0)| 00:00:01 | | | |
|* 17 | INDEX UNIQUE SCAN | PK_BD_DEFDOC | 1 | | | 1 (0)| 00:00:01 | | | |
| 18 | TABLE ACCESS BY INDEX ROWID | BD_CORP | 1 | 31 | | 1 (0)| 00:00:01 | | | |
|* 19 | INDEX UNIQUE SCAN | PK_BD_CORP | 1 | | | 1 (0)| 00:00:01 | | | |
| 20 | VIEW | | 746 | 25364 | | 53204 (1)| 00:10:39 | | | |
| 21 | HASH GROUP BY | | 746 | 54458 | | 53204 (1)| 00:10:39 | | | |
| 22 | VIEW | | 222K| 15M| | 53204 (1)| 00:10:39 | | | |
| 23 | HASH UNIQUE | | 222K| 157M| 348M| 53204 (1)| 00:10:39 | | | |
| 24 | NESTED LOOPS OUTER | | 222K| 157M| | 18352 (3)| 00:03:41 | | | |
|* 25 | HASH JOIN RIGHT OUTER | | 222K| 143M| | 18348 (3)| 00:03:41 | 1011K| 1011K| 1280K (0)|
| 26 | TABLE ACCESS FULL | BD_CORP | 587 | 3522 | | 11 (0)| 00:00:01 | | | |
|* 27 | HASH JOIN RIGHT OUTER | | 222K| 142M| | 18333 (3)| 00:03:40 | 909K| 909K| 1255K (0)|
| 28 | TABLE ACCESS FULL | ARAP_DJLX | 195 | 3705 | | 6 (0)| 00:00:01 | | | |
|* 29 | HASH JOIN RIGHT OUTER | | 222K| 138M| | 18324 (3)| 00:03:40 | 878K| 878K| 1339K (0)|
| 30 | TABLE ACCESS FULL | BD_COSTSUBJ | 2472 | 318K| | 13 (0)| 00:00:01 | | | |
|* 31 | HASH JOIN | | 222K| 110M| | 18308 (3)| 00:03:40 | 829K| 829K| 1321K (0)|
| 32 | INDEX FAST FULL SCAN | PK_BD_ACCID | 2225 | 73425 | | 4 (0)| 00:00:01 | | | |
| 33 | NESTED LOOPS OUTER | | 366K| 169M| | 18299 (3)| 00:03:40 | | | |
| 34 | NESTED LOOPS OUTER | | 366K| 146M| | 18266 (2)| 00:03:40 | | | |
| 35 | NESTED LOOPS OUTER | | 366K| 123M| | 18232 (2)| 00:03:39 | | | |
|* 36 | HASH JOIN RIGHT OUTER | | 366K| 100M| | 18199 (2)| 00:03:39 | 977K| 977K| 1298K (0)|
| 37 | TABLE ACCESS FULL | BD_ACCID | 2225 | 141K| | 22 (0)| 00:00:01 | | | |
|* 38 | HASH JOIN | | 366K| 77M| 20M| 18171 (2)| 00:03:39 | 29M| 4050K| 33M (0)|
|* 39 | TABLE ACCESS FULL | ARAP_DJZB | 211K| 18M| | 2835 (3)| 00:00:35 | | | |
|* 40 | TABLE ACCESS FULL | ARAP_DJFB | 366K| 46M| | 11786 (2)| 00:02:22 | | | |
| 41 | TABLE ACCESS BY INDEX ROWID| BD_DEFDOC | 1 | 66 | | 1 (0)| 00:00:01 | | | |
|* 42 | INDEX UNIQUE SCAN | PK_BD_DEFDOC | 1 | | | 1 (0)| 00:00:01 | | | |
| 43 | TABLE ACCESS BY INDEX ROWID | BD_DEFDOC | 1 | 66 | | 1 (0)| 00:00:01 | | | |
|* 44 | INDEX UNIQUE SCAN | PK_BD_DEFDOC | 1 | | | 1 (0)| 00:00:01 | | | |
| 45 | TABLE ACCESS BY INDEX ROWID | BD_DEFDOC | 1 | 66 | | 1 (0)| 00:00:01 | | | |
|* 46 | INDEX UNIQUE SCAN | PK_BD_DEFDOC | 1 | | | 1 (0)| 00:00:01 | | | |
| 47 | TABLE ACCESS BY INDEX ROWID | BD_DEFDOC | 1 | 66 | | 1 (0)| 00:00:01 | | | |
|* 48 | INDEX UNIQUE SCAN | PK_BD_DEFDOC | 1 | | | 1 (0)| 00:00:01 | | | |
------------------------------------------------------------------------------------------------------------------------------------------------
Query Block Name / Object Alias (identified by operation id):
-------------------------------------------------------------
1 - SEL$F8AE1ACE
9 - SEL$F8AE1ACE / AREADEF@SEL$10
10 - SEL$F8AE1ACE / AREADEF@SEL$10
11 - SEL$F8AE1ACE / ACCID@SEL$3
12 - SEL$F8AE1ACE / DEFDOC1@SEL$4
13 - SEL$F8AE1ACE / DEFDOC1@SEL$4
14 - SEL$F8AE1ACE / ACCBANK@SEL$2
15 - SEL$F8AE1ACE / ACCBANK@SEL$2
16 - SEL$F8AE1ACE / DEFDOC2@SEL$6
17 - SEL$F8AE1ACE / DEFDOC2@SEL$6
18 - SEL$F8AE1ACE / CORP@SEL$8
19 - SEL$F8AE1ACE / CORP@SEL$8
20 - SEL$EE770137 / B@SEL$1
21 - SEL$EE770137
22 - SEL$8E581076 / $vm_view@SEL$EE770137
23 - SEL$8E581076
26 - SEL$8E581076 / CORP@SEL$25
28 - SEL$8E581076 / DJLX@SEL$15
30 - SEL$8E581076 / SUBJ@SEL$17
32 - SEL$8E581076 / ACCID@SEL$13
37 - SEL$8E581076 / ACCID@SEL$19
39 - SEL$8E581076 / ZB@SEL$14
40 - SEL$8E581076 / FB@SEL$14
41 - SEL$8E581076 / DEFDOC4@SEL$29
42 - SEL$8E581076 / DEFDOC4@SEL$29
43 - SEL$8E581076 / DEFDOC20@SEL$23
44 - SEL$8E581076 / DEFDOC20@SEL$23
45 - SEL$8E581076 / DEFDOC1@SEL$21
46 - SEL$8E581076 / DEFDOC1@SEL$21
47 - SEL$8E581076 / CORPDEF@SEL$27
48 - SEL$8E581076 / CORPDEF@SEL$27
Outline Data
-------------
/*+
BEGIN_OUTLINE_DATA
IGNORE_OPTIM_EMBEDDED_HINTS
OPTIMIZER_FEATURES_ENABLE('10.2.0.1')
OPT_PARAM('optimizer_dynamic_sampling' 4)
OPT_PARAM('optimizer_index_cost_adj' 40)
ALL_ROWS
OUTLINE_LEAF(@"SEL$8E581076")
MERGE(@"SEL$46E4F78E")
OUTLINE_LEAF(@"SEL$EE770137")
OUTLINE_LEAF(@"SEL$F8AE1ACE")
MERGE(@"SEL$DACD4884")
OUTLINE(@"SEL$CB3744F9")
OUTLINE(@"SEL$46E4F78E")
MERGE(@"SEL$39805560")
OUTLINE(@"SEL$13")
OUTLINE(@"SEL$EE770137")
OUTLINE(@"SEL$6E71C6F6")
ELIMINATE_OUTER_JOIN(@"SEL$1")
OUTLINE(@"SEL$DACD4884")
MERGE(@"SEL$47287008")
OUTLINE(@"SEL$31")
OUTLINE(@"SEL$39805560")
MERGE(@"SEL$29")
MERGE(@"SEL$AC0A1522")
OUTLINE(@"SEL$1")
OUTLINE(@"SEL$12")
OUTLINE(@"SEL$47287008")
MERGE(@"SEL$10")
MERGE(@"SEL$A4670989")
OUTLINE(@"SEL$30")
OUTLINE(@"SEL$29")
OUTLINE(@"SEL$AC0A1522")
MERGE(@"SEL$27")
MERGE(@"SEL$5A9F8532")
OUTLINE(@"SEL$11")
OUTLINE(@"SEL$10")
OUTLINE(@"SEL$A4670989")
MERGE(@"SEL$4FF72BDF")
MERGE(@"SEL$8")
OUTLINE(@"SEL$28")
OUTLINE(@"SEL$27")
OUTLINE(@"SEL$5A9F8532")
MERGE(@"SEL$25")
MERGE(@"SEL$903B4AC9")
OUTLINE(@"SEL$9")
OUTLINE(@"SEL$4FF72BDF")
MERGE(@"SEL$6")
MERGE(@"SEL$829C93BE")
OUTLINE(@"SEL$8")
OUTLINE(@"SEL$26")
OUTLINE(@"SEL$25")
OUTLINE(@"SEL$903B4AC9")
MERGE(@"SEL$23")
MERGE(@"SEL$343FF06E")
OUTLINE(@"SEL$7")
OUTLINE(@"SEL$6")
OUTLINE(@"SEL$829C93BE")
MERGE(@"SEL$4")
MERGE(@"SEL$64EAE176")
OUTLINE(@"SEL$24")
OUTLINE(@"SEL$23")
OUTLINE(@"SEL$343FF06E")
MERGE(@"SEL$21")
MERGE(@"SEL$EDE155A4")
OUTLINE(@"SEL$5")
OUTLINE(@"SEL$4")
OUTLINE(@"SEL$64EAE176")
MERGE(@"SEL$2")
OUTLINE(@"SEL$22")
OUTLINE(@"SEL$21")
OUTLINE(@"SEL$EDE155A4")
MERGE(@"SEL$19")
MERGE(@"SEL$D7D4BC85")
OUTLINE(@"SEL$3")
OUTLINE(@"SEL$2")
OUTLINE(@"SEL$20")
OUTLINE(@"SEL$19")
OUTLINE(@"SEL$D7D4BC85")
MERGE(@"SEL$17")
MERGE(@"SEL$CC31A32C")
OUTLINE(@"SEL$18")
OUTLINE(@"SEL$17")
OUTLINE(@"SEL$CC31A32C")
MERGE(@"SEL$14")
MERGE(@"SEL$15")
OUTLINE(@"SEL$16")
OUTLINE(@"SEL$14")
OUTLINE(@"SEL$15")
INDEX(@"SEL$F8AE1ACE" "AREADEF"@"SEL$10" ("BD_DEFDOC"."PK_DEFDOC"))
FULL(@"SEL$F8AE1ACE" "ACCID"@"SEL$3")
INDEX(@"SEL$F8AE1ACE" "DEFDOC1"@"SEL$4" ("BD_DEFDOC"."PK_DEFDOC"))
INDEX(@"SEL$F8AE1ACE" "ACCBANK"@"SEL$2" ("BD_ACCBANK"."PK_ACCBANK"))
INDEX(@"SEL$F8AE1ACE" "DEFDOC2"@"SEL$6" ("BD_DEFDOC"."PK_DEFDOC"))
INDEX(@"SEL$F8AE1ACE" "CORP"@"SEL$8" ("BD_CORP"."PK_CORP"))
NO_ACCESS(@"SEL$F8AE1ACE" "B"@"SEL$1")
LEADING(@"SEL$F8AE1ACE" "AREADEF"@"SEL$10" "ACCID"@"SEL$3" "DEFDOC1"@"SEL$4" "ACCBANK"@"SEL$2" "DEFDOC2"@"SEL$6" "CORP"@"SEL$8"
"B"@"SEL$1")
USE_NL(@"SEL$F8AE1ACE" "ACCID"@"SEL$3")
USE_NL(@"SEL$F8AE1ACE" "DEFDOC1"@"SEL$4")
USE_NL(@"SEL$F8AE1ACE" "ACCBANK"@"SEL$2")
USE_NL(@"SEL$F8AE1ACE" "DEFDOC2"@"SEL$6")
USE_NL(@"SEL$F8AE1ACE" "CORP"@"SEL$8")
USE_HASH(@"SEL$F8AE1ACE" "B"@"SEL$1")
NO_ACCESS(@"SEL$EE770137" "$vm_view"@"SEL$EE770137")
FULL(@"SEL$8E581076" "ZB"@"SEL$14")
FULL(@"SEL$8E581076" "FB"@"SEL$14")
FULL(@"SEL$8E581076" "ACCID"@"SEL$19")
INDEX(@"SEL$8E581076" "DEFDOC4"@"SEL$29" ("BD_DEFDOC"."PK_DEFDOC"))
INDEX(@"SEL$8E581076" "DEFDOC20"@"SEL$23" ("BD_DEFDOC"."PK_DEFDOC"))
INDEX(@"SEL$8E581076" "DEFDOC1"@"SEL$21" ("BD_DEFDOC"."PK_DEFDOC"))
INDEX_FFS(@"SEL$8E581076" "ACCID"@"SEL$13" ("BD_ACCID"."PK_ACCID"))
FULL(@"SEL$8E581076" "SUBJ"@"SEL$17")
FULL(@"SEL$8E581076" "DJLX"@"SEL$15")
FULL(@"SEL$8E581076" "CORP"@"SEL$25")
INDEX(@"SEL$8E581076" "CORPDEF"@"SEL$27" ("BD_DEFDOC"."PK_DEFDOC"))
LEADING(@"SEL$8E581076" "ZB"@"SEL$14" "FB"@"SEL$14" "ACCID"@"SEL$19" "DEFDOC4"@"SEL$29" "DEFDOC20"@"SEL$23" "DEFDOC1"@"SEL$21"
"ACCID"@"SEL$13" "SUBJ"@"SEL$17" "DJLX"@"SEL$15" "CORP"@"SEL$25" "CORPDEF"@"SEL$27")
USE_HASH(@"SEL$8E581076" "FB"@"SEL$14")
USE_HASH(@"SEL$8E581076" "ACCID"@"SEL$19")
USE_NL(@"SEL$8E581076" "DEFDOC4"@"SEL$29")
USE_NL(@"SEL$8E581076" "DEFDOC20"@"SEL$23")
USE_NL(@"SEL$8E581076" "DEFDOC1"@"SEL$21")
USE_HASH(@"SEL$8E581076" "ACCID"@"SEL$13")
USE_HASH(@"SEL$8E581076" "SUBJ"@"SEL$17")
USE_HASH(@"SEL$8E581076" "DJLX"@"SEL$15")
USE_HASH(@"SEL$8E581076" "CORP"@"SEL$25")
USE_NL(@"SEL$8E581076" "CORPDEF"@"SEL$27")
SWAP_JOIN_INPUTS(@"SEL$8E581076" "ACCID"@"SEL$19")
SWAP_JOIN_INPUTS(@"SEL$8E581076" "ACCID"@"SEL$13")
SWAP_JOIN_INPUTS(@"SEL$8E581076" "SUBJ"@"SEL$17")
SWAP_JOIN_INPUTS(@"SEL$8E581076" "DJLX"@"SEL$15")
SWAP_JOIN_INPUTS(@"SEL$8E581076" "CORP"@"SEL$25")
END_OUTLINE_DATA
*/
Predicate Information (identified by operation id):
---------------------------------------------------
2 - filter(NVL("ACCID"."BEGINBMNY",0)+NVL("BBJE",0)<>0)
3 - access("ACCID"."PK_ACCID"="B"."PK_ACCID")
10 - access("AREADEF"."PK_DEFDOC"='0001V5100000000CABMI')
11 - filter((NVL("ACCID"."DR",0)=0 AND "ACCID"."DEF20"='0001V5100000000CABMI'))
13 - access("DEFDOC1"."PK_DEFDOC"="ACCID"."DEF1")
15 - access("ACCID"."PK_ACCBANK"="ACCBANK"."PK_ACCBANK")
17 - access("DEFDOC2"."PK_DEFDOC"="ACCID"."DEF2")
19 - access("CORP"."PK_CORP"="ACCID"."PK_CORP")
25 - access("CORP"."PK_CORP"="ZB"."DWBM")
27 - access("ZB"."DJLXBM"="DJLX"."DJLXBM" AND "ZB"."DWBM"="DJLX"."DWBM" AND "ZB"."DJDL"="DJLX"."DJDL")
29 - access("SUBJ"."PK_COSTSUBJ"="FB"."SZXMID")
31 - access("ACCID"."PK_ACCID"="FB"."ACCOUNTID")
36 - access("ACCID"."PK_ACCID"="FB"."ACCOUNTID")
38 - access("ZB"."VOUCHID"="FB"."VOUCHID")
39 - filter((INTERNAL_FUNCTION("ZB"."DJDL") AND "ZB"."DJZT"=2 AND NVL("ZB"."DR",0)=0 AND "ZB"."QCBZ"='N' AND
"ZB"."SHRQ"<='2012-05-11'))
40 - filter(("FB"."ACCOUNTID" IS NOT NULL AND NVL("FB"."DR",0)=0))
42 - access("DEFDOC4"."PK_DEFDOC"="ACCID"."DEF2")
44 - access("DEFDOC20"."PK_DEFDOC"="ACCID"."DEF20")
46 - access("DEFDOC1"."PK_DEFDOC"="ACCID"."DEF1")
48 - access("CORPDEF"."PK_DEFDOC"="CORP"."DEF1")
Note
-----
- dynamic sampling used for this statement
- Warning: basic plan statistics not available. These are only collected when:
* hint 'gather_plan_statistics' is used for the statement or
* parameter 'statistics_level' is set to 'ALL', at session or system level
Inst: 1 Child: 0 Plan hash value: 580003853
------------------------------------------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | E-Rows |E-Bytes|E-Temp | Cost (%CPU)| E-Time | OMem | 1Mem | O/1/M |
------------------------------------------------------------------------------------------------------------------------------------------------
| 1 | SORT ORDER BY | | 1 | 358 | | 53233 (1)| 00:10:39 | 27648 | 27648 | 2/0/0|
|* 2 | FILTER | | | | | | | | | |
|* 3 | HASH JOIN OUTER | | 1 | 358 | | 53232 (1)| 00:10:39 | 737K| 737K| 2/0/0|
| 4 | NESTED LOOPS OUTER | | 1 | 324 | | 27 (0)| 00:00:01 | | | |
| 5 | NESTED LOOPS OUTER | | 1 | 293 | | 26 (0)| 00:00:01 | | | |
| 6 | NESTED LOOPS OUTER | | 1 | 227 | | 25 (0)| 00:00:01 | | | |
| 7 | NESTED LOOPS | | 1 | 164 | | 24 (0)| 00:00:01 | | | |
| 8 | NESTED LOOPS | | 362 | 35476 | | 23 (0)| 00:00:01 | | | |
| 9 | TABLE ACCESS BY INDEX ROWID | BD_DEFDOC | 1 | 66 | | 1 (0)| 00:00:01 | | | |
|* 10 | INDEX UNIQUE SCAN | PK_BD_DEFDOC | 1 | | | 1 (0)| 00:00:01 | | | |
|* 11 | TABLE ACCESS FULL | BD_ACCID | 362 | 11584 | | 22 (0)| 00:00:01 | | | |
| 12 | TABLE ACCESS BY INDEX ROWID | BD_DEFDOC | 1 | 66 | | 1 (0)| 00:00:01 | | | |
|* 13 | INDEX UNIQUE SCAN | PK_BD_DEFDOC | 1 | | | 1 (0)| 00:00:01 | | | |
| 14 | TABLE ACCESS BY INDEX ROWID | BD_ACCBANK | 1 | 63 | | 1 (0)| 00:00:01 | | | |
|* 15 | INDEX UNIQUE SCAN | PK_BD_ACCBANK | 1 | | | 1 (0)| 00:00:01 | | | |
| 16 | TABLE ACCESS BY INDEX ROWID | BD_DEFDOC | 1 | 66 | | 1 (0)| 00:00:01 | | | |
|* 17 | INDEX UNIQUE SCAN | PK_BD_DEFDOC | 1 | | | 1 (0)| 00:00:01 | | | |
| 18 | TABLE ACCESS BY INDEX ROWID | BD_CORP | 1 | 31 | | 1 (0)| 00:00:01 | | | |
|* 19 | INDEX UNIQUE SCAN | PK_BD_CORP | 1 | | | 1 (0)| 00:00:01 | | | |
| 20 | VIEW | | 746 | 25364 | | 53204 (1)| 00:10:39 | | | |
| 21 | HASH GROUP BY | | 746 | 54458 | | 53204 (1)| 00:10:39 | | | |
| 22 | VIEW | | 222K| 15M| | 53204 (1)| 00:10:39 | | | |
| 23 | HASH UNIQUE | | 222K| 157M| 348M| 53204 (1)| 00:10:39 | | | |
| 24 | NESTED LOOPS OUTER | | 222K| 157M| | 18352 (3)| 00:03:41 | | | |
|* 25 | HASH JOIN RIGHT OUTER | | 222K| 143M| | 18348 (3)| 00:03:41 | 1011K| 1011K| 2/0/0|
| 26 | TABLE ACCESS FULL | BD_CORP | 587 | 3522 | | 11 (0)| 00:00:01 | | | |
|* 27 | HASH JOIN RIGHT OUTER | | 222K| 142M| | 18333 (3)| 00:03:40 | 909K| 909K| 2/0/0|
| 28 | TABLE ACCESS FULL | ARAP_DJLX | 195 | 3705 | | 6 (0)| 00:00:01 | | | |
|* 29 | HASH JOIN RIGHT OUTER | | 222K| 138M| | 18324 (3)| 00:03:40 | 878K| 878K| 2/0/0|
| 30 | TABLE ACCESS FULL | BD_COSTSUBJ | 2472 | 318K| | 13 (0)| 00:00:01 | | | |
|* 31 | HASH JOIN | | 222K| 110M| | 18308 (3)| 00:03:40 | 829K| 829K| 2/0/0|
| 32 | INDEX FAST FULL SCAN | PK_BD_ACCID | 2225 | 73425 | | 4 (0)| 00:00:01 | | | |
| 33 | NESTED LOOPS OUTER | | 366K| 169M| | 18299 (3)| 00:03:40 | | | |
| 34 | NESTED LOOPS OUTER | | 366K| 146M| | 18266 (2)| 00:03:40 | | | |
| 35 | NESTED LOOPS OUTER | | 366K| 123M| | 18232 (2)| 00:03:39 | | | |
|* 36 | HASH JOIN RIGHT OUTER | | 366K| 100M| | 18199 (2)| 00:03:39 | 977K| 977K| 2/0/0|
| 37 | TABLE ACCESS FULL | BD_ACCID | 2225 | 141K| | 22 (0)| 00:00:01 | | | |
|* 38 | HASH JOIN | | 366K| 77M| 20M| 18171 (2)| 00:03:39 | 29M| 4050K| 2/0/0|
|* 39 | TABLE ACCESS FULL | ARAP_DJZB | 211K| 18M| | 2835 (3)| 00:00:35 | | | |
|* 40 | TABLE ACCESS FULL | ARAP_DJFB | 366K| 46M| | 11786 (2)| 00:02:22 | | | |
| 41 | TABLE ACCESS BY INDEX ROWID| BD_DEFDOC | 1 | 66 | | 1 (0)| 00:00:01 | | | |
|* 42 | INDEX UNIQUE SCAN | PK_BD_DEFDOC | 1 | | | 1 (0)| 00:00:01 | | | |
| 43 | TABLE ACCESS BY INDEX ROWID | BD_DEFDOC | 1 | 66 | | 1 (0)| 00:00:01 | | | |
|* 44 | INDEX UNIQUE SCAN | PK_BD_DEFDOC | 1 | | | 1 (0)| 00:00:01 | | | |
| 45 | TABLE ACCESS BY INDEX ROWID | BD_DEFDOC | 1 | 66 | | 1 (0)| 00:00:01 | | | |
|* 46 | INDEX UNIQUE SCAN | PK_BD_DEFDOC | 1 | | | 1 (0)| 00:00:01 | | | |
| 47 | TABLE ACCESS BY INDEX ROWID | BD_DEFDOC | 1 | 66 | | 1 (0)| 00:00:01 | | | |
|* 48 | INDEX UNIQUE SCAN | PK_BD_DEFDOC | 1 | | | 1 (0)| 00:00:01 | | | |
------------------------------------------------------------------------------------------------------------------------------------------------
Query Block Name / Object Alias (identified by operation id):
-------------------------------------------------------------
1 - SEL$F8AE1ACE
9 - SEL$F8AE1ACE / AREADEF@SEL$10
10 - SEL$F8AE1ACE / AREADEF@SEL$10
11 - SEL$F8AE1ACE / ACCID@SEL$3
12 - SEL$F8AE1ACE / DEFDOC1@SEL$4
13 - SEL$F8AE1ACE / DEFDOC1@SEL$4
14 - SEL$F8AE1ACE / ACCBANK@SEL$2
15 - SEL$F8AE1ACE / ACCBANK@SEL$2
16 - SEL$F8AE1ACE / DEFDOC2@SEL$6
17 - SEL$F8AE1ACE / DEFDOC2@SEL$6
18 - SEL$F8AE1ACE / CORP@SEL$8
19 - SEL$F8AE1ACE / CORP@SEL$8
20 - SEL$EE770137 / B@SEL$1
21 - SEL$EE770137
22 - SEL$8E581076 / $vm_view@SEL$EE770137
23 - SEL$8E581076
26 - SEL$8E581076 / CORP@SEL$25
28 - SEL$8E581076 / DJLX@SEL$15
30 - SEL$8E581076 / SUBJ@SEL$17
32 - SEL$8E581076 / ACCID@SEL$13
37 - SEL$8E581076 / ACCID@SEL$19
39 - SEL$8E581076 / ZB@SEL$14
40 - SEL$8E581076 / FB@SEL$14
41 - SEL$8E581076 / DEFDOC4@SEL$29
42 - SEL$8E581076 / DEFDOC4@SEL$29
43 - SEL$8E581076 / DEFDOC20@SEL$23
44 - SEL$8E581076 / DEFDOC20@SEL$23
45 - SEL$8E581076 / DEFDOC1@SEL$21
46 - SEL$8E581076 / DEFDOC1@SEL$21
47 - SEL$8E581076 / CORPDEF@SEL$27
48 - SEL$8E581076 / CORPDEF@SEL$27
Outline Data
-------------
/*+
BEGIN_OUTLINE_DATA
IGNORE_OPTIM_EMBEDDED_HINTS
OPTIMIZER_FEATURES_ENABLE('10.2.0.1')
OPT_PARAM('optimizer_dynamic_sampling' 4)
OPT_PARAM('optimizer_index_cost_adj' 40)
ALL_ROWS
OUTLINE_LEAF(@"SEL$8E581076")
MERGE(@"SEL$46E4F78E")
OUTLINE_LEAF(@"SEL$EE770137")
OUTLINE_LEAF(@"SEL$F8AE1ACE")
MERGE(@"SEL$DACD4884")
OUTLINE(@"SEL$CB3744F9")
OUTLINE(@"SEL$46E4F78E")
MERGE(@"SEL$39805560")
OUTLINE(@"SEL$13")
OUTLINE(@"SEL$EE770137")
OUTLINE(@"SEL$6E71C6F6")
ELIMINATE_OUTER_JOIN(@"SEL$1")
OUTLINE(@"SEL$DACD4884")
MERGE(@"SEL$47287008")
OUTLINE(@"SEL$31")
OUTLINE(@"SEL$39805560")
MERGE(@"SEL$29")
MERGE(@"SEL$AC0A1522")
OUTLINE(@"SEL$1")
OUTLINE(@"SEL$12")
OUTLINE(@"SEL$47287008")
MERGE(@"SEL$10")
MERGE(@"SEL$A4670989")
OUTLINE(@"SEL$30")
OUTLINE(@"SEL$29")
OUTLINE(@"SEL$AC0A1522")
MERGE(@"SEL$27")
MERGE(@"SEL$5A9F8532")
OUTLINE(@"SEL$11")
OUTLINE(@"SEL$10")
OUTLINE(@"SEL$A4670989")
MERGE(@"SEL$4FF72BDF")
MERGE(@"SEL$8")
OUTLINE(@"SEL$28")
OUTLINE(@"SEL$27")
OUTLINE(@"SEL$5A9F8532")
MERGE(@"SEL$25")
MERGE(@"SEL$903B4AC9")
OUTLINE(@"SEL$9")
OUTLINE(@"SEL$4FF72BDF")
MERGE(@"SEL$6")
MERGE(@"SEL$829C93BE")
OUTLINE(@"SEL$8")
OUTLINE(@"SEL$26")
OUTLINE(@"SEL$25")
OUTLINE(@"SEL$903B4AC9")
MERGE(@"SEL$23")
MERGE(@"SEL$343FF06E")
OUTLINE(@"SEL$7")
OUTLINE(@"SEL$6")
OUTLINE(@"SEL$829C93BE")
MERGE(@"SEL$4")
MERGE(@"SEL$64EAE176")
OUTLINE(@"SEL$24")
OUTLINE(@"SEL$23")
OUTLINE(@"SEL$343FF06E")
MERGE(@"SEL$21")
MERGE(@"SEL$EDE155A4")
OUTLINE(@"SEL$5")
OUTLINE(@"SEL$4")
OUTLINE(@"SEL$64EAE176")
MERGE(@"SEL$2")
OUTLINE(@"SEL$22")
OUTLINE(@"SEL$21")
OUTLINE(@"SEL$EDE155A4")
MERGE(@"SEL$19")
MERGE(@"SEL$D7D4BC85")
OUTLINE(@"SEL$3")
OUTLINE(@"SEL$2")
OUTLINE(@"SEL$20")
OUTLINE(@"SEL$19")
OUTLINE(@"SEL$D7D4BC85")
MERGE(@"SEL$17")
MERGE(@"SEL$CC31A32C")
OUTLINE(@"SEL$18")
OUTLINE(@"SEL$17")
OUTLINE(@"SEL$CC31A32C")
MERGE(@"SEL$14")
MERGE(@"SEL$15")
OUTLINE(@"SEL$16")
OUTLINE(@"SEL$14")
OUTLINE(@"SEL$15")
INDEX(@"SEL$F8AE1ACE" "AREADEF"@"SEL$10" ("BD_DEFDOC"."PK_DEFDOC"))
FULL(@"SEL$F8AE1ACE" "ACCID"@"SEL$3")
INDEX(@"SEL$F8AE1ACE" "DEFDOC1"@"SEL$4" ("BD_DEFDOC"."PK_DEFDOC"))
INDEX(@"SEL$F8AE1ACE" "ACCBANK"@"SEL$2" ("BD_ACCBANK"."PK_ACCBANK"))
INDEX(@"SEL$F8AE1ACE" "DEFDOC2"@"SEL$6" ("BD_DEFDOC"."PK_DEFDOC"))
INDEX(@"SEL$F8AE1ACE" "CORP"@"SEL$8" ("BD_CORP"."PK_CORP"))
NO_ACCESS(@"SEL$F8AE1ACE" "B"@"SEL$1")
LEADING(@"SEL$F8AE1ACE" "AREADEF"@"SEL$10" "ACCID"@"SEL$3" "DEFDOC1"@"SEL$4" "ACCBANK"@"SEL$2" "DEFDOC2"@"SEL$6" "CORP"@"SEL$8"
"B"@"SEL$1")
USE_NL(@"SEL$F8AE1ACE" "ACCID"@"SEL$3")
USE_NL(@"SEL$F8AE1ACE" "DEFDOC1"@"SEL$4")
USE_NL(@"SEL$F8AE1ACE" "ACCBANK"@"SEL$2")
USE_NL(@"SEL$F8AE1ACE" "DEFDOC2"@"SEL$6")
USE_NL(@"SEL$F8AE1ACE" "CORP"@"SEL$8")
USE_HASH(@"SEL$F8AE1ACE" "B"@"SEL$1")
NO_ACCESS(@"SEL$EE770137" "$vm_view"@"SEL$EE770137")
FULL(@"SEL$8E581076" "ZB"@"SEL$14")
FULL(@"SEL$8E581076" "FB"@"SEL$14")
FULL(@"SEL$8E581076" "ACCID"@"SEL$19")
INDEX(@"SEL$8E581076" "DEFDOC4"@"SEL$29" ("BD_DEFDOC"."PK_DEFDOC"))
INDEX(@"SEL$8E581076" "DEFDOC20"@"SEL$23" ("BD_DEFDOC"."PK_DEFDOC"))
INDEX(@"SEL$8E581076" "DEFDOC1"@"SEL$21" ("BD_DEFDOC"."PK_DEFDOC"))
INDEX_FFS(@"SEL$8E581076" "ACCID"@"SEL$13" ("BD_ACCID"."PK_ACCID"))
FULL(@"SEL$8E581076" "SUBJ"@"SEL$17")
FULL(@"SEL$8E581076" "DJLX"@"SEL$15")
FULL(@"SEL$8E581076" "CORP"@"SEL$25")
INDEX(@"SEL$8E581076" "CORPDEF"@"SEL$27" ("BD_DEFDOC"."PK_DEFDOC"))
LEADING(@"SEL$8E581076" "ZB"@"SEL$14" "FB"@"SEL$14" "ACCID"@"SEL$19" "DEFDOC4"@"SEL$29" "DEFDOC20"@"SEL$23" "DEFDOC1"@"SEL$21"
"ACCID"@"SEL$13" "SUBJ"@"SEL$17" "DJLX"@"SEL$15" "CORP"@"SEL$25" "CORPDEF"@"SEL$27")
USE_HASH(@"SEL$8E581076" "FB"@"SEL$14")
USE_HASH(@"SEL$8E581076" "ACCID"@"SEL$19")
USE_NL(@"SEL$8E581076" "DEFDOC4"@"SEL$29")
USE_NL(@"SEL$8E581076" "DEFDOC20"@"SEL$23")
USE_NL(@"SEL$8E581076" "DEFDOC1"@"SEL$21")
USE_HASH(@"SEL$8E581076" "ACCID"@"SEL$13")
USE_HASH(@"SEL$8E581076" "SUBJ"@"SEL$17")
USE_HASH(@"SEL$8E581076" "DJLX"@"SEL$15")
USE_HASH(@"SEL$8E581076" "CORP"@"SEL$25")
USE_NL(@"SEL$8E581076" "CORPDEF"@"SEL$27")
SWAP_JOIN_INPUTS(@"SEL$8E581076" "ACCID"@"SEL$19")
SWAP_JOIN_INPUTS(@"SEL$8E581076" "ACCID"@"SEL$13")
SWAP_JOIN_INPUTS(@"SEL$8E581076" "SUBJ"@"SEL$17")
SWAP_JOIN_INPUTS(@"SEL$8E581076" "DJLX"@"SEL$15")
SWAP_JOIN_INPUTS(@"SEL$8E581076" "CORP"@"SEL$25")
END_OUTLINE_DATA
*/
Predicate Information (identified by operation id):
---------------------------------------------------
2 - filter(NVL("ACCID"."BEGINBMNY",0)+NVL("BBJE",0)<>0)
3 - access("ACCID"."PK_ACCID"="B"."PK_ACCID")
10 - access("AREADEF"."PK_DEFDOC"='0001V5100000000CABMI')
11 - filter((NVL("ACCID"."DR",0)=0 AND "ACCID"."DEF20"='0001V5100000000CABMI'))
13 - access("DEFDOC1"."PK_DEFDOC"="ACCID"."DEF1")
15 - access("ACCID"."PK_ACCBANK"="ACCBANK"."PK_ACCBANK")
17 - access("DEFDOC2"."PK_DEFDOC"="ACCID"."DEF2")
19 - access("CORP"."PK_CORP"="ACCID"."PK_CORP")
25 - access("CORP"."PK_CORP"="ZB"."DWBM")
27 - access("ZB"."DJLXBM"="DJLX"."DJLXBM" AND "ZB"."DWBM"="DJLX"."DWBM" AND "ZB"."DJDL"="DJLX"."DJDL")
29 - access("SUBJ"."PK_COSTSUBJ"="FB"."SZXMID")
31 - access("ACCID"."PK_ACCID"="FB"."ACCOUNTID")
36 - access("ACCID"."PK_ACCID"="FB"."ACCOUNTID")
38 - access("ZB"."VOUCHID"="FB"."VOUCHID")
39 - filter((INTERNAL_FUNCTION("ZB"."DJDL") AND "ZB"."DJZT"=2 AND NVL("ZB"."DR",0)=0 AND "ZB"."QCBZ"='N' AND
"ZB"."SHRQ"<='2012-05-11'))
40 - filter(("FB"."ACCOUNTID" IS NOT NULL AND NVL("FB"."DR",0)=0))
42 - access("DEFDOC4"."PK_DEFDOC"="ACCID"."DEF2")
44 - access("DEFDOC20"."PK_DEFDOC"="ACCID"."DEF20")
46 - access("DEFDOC1"."PK_DEFDOC"="ACCID"."DEF1")
48 - access("CORPDEF"."PK_DEFDOC"="CORP"."DEF1")
Note
-----
- dynamic sampling used for this statement
- Warning: basic plan statistics not available. These are only collected when:
* hint 'gather_plan_statistics' is used for the statement or
* parameter 'statistics_level' is set to 'ALL', at session or system level