1366133.1 SQLHC 11.4.4.1 Report: sqlhc_UAT_apptest_11.1.0.7.0_gm7ak5qtcrd3m_20130924133324.html

License : "Y"
SQL_ID  : "gm7ak5qtcrd3m"
RDBMS   : "11.1.0.7.0"
Platform: "IBM/AIX RISC SYSTEM/6000"
OFE     : "11.1.0.7"
DYN_SAMP: "2"
EBS:      "Y"
SIEBEL  : ""
PSFT    : ""
Date    : "2013-09-24/13:33:24"

Observations

Observations below are the outcome of several heath-checks on the schema objects accessed by your SQL and its environment. Review them carefully and take action when appropriate. Then re-execute your SQL and generate this report again.
# Type Name Observation More
1 CBO PARAMETER CURSOR_SHARING CBO initialization parameter "cursor_sharing" with a non-default value of "force" as per V$SQL_OPTIMIZER_ENV. Review the correctness of this non-default value "force" for SQL_ID gm7ak5qtcrd3m.
2 CBO PARAMETER OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES CBO initialization parameter "optimizer_capture_sql_plan_baselines" with a non-default value of "true" as per V$SQL_OPTIMIZER_ENV. Review the correctness of this non-default value "true" for SQL_ID gm7ak5qtcrd3m.
3 CBO PARAMETER OPTIMIZER_SECURE_VIEW_MERGING CBO initialization parameter "optimizer_secure_view_merging" with a non-default value of "false" as per V$SQL_OPTIMIZER_ENV. Review the correctness of this non-default value "false" for SQL_ID gm7ak5qtcrd3m.
4 CBO PARAMETER _B_TREE_BITMAP_PLANS CBO initialization parameter "_b_tree_bitmap_plans" with a non-default value of "false" as per V$SQL_OPTIMIZER_ENV. Review the correctness of this non-default value "false" for SQL_ID gm7ak5qtcrd3m.
5 CBO PARAMETER _FAST_FULL_SCAN_ENABLED CBO initialization parameter "_fast_full_scan_enabled" with a non-default value of "false" as per V$SQL_OPTIMIZER_ENV. Review the correctness of this non-default value "false" for SQL_ID gm7ak5qtcrd3m.
6 CBO PARAMETER _INDEX_JOIN_ENABLED CBO initialization parameter "_index_join_enabled" with a non-default value of "false" as per V$SQL_OPTIMIZER_ENV. Review the correctness of this non-default value "false" for SQL_ID gm7ak5qtcrd3m.
7 CBO PARAMETER _LIKE_WITH_BIND_AS_EQUALITY CBO initialization parameter "_like_with_bind_as_equality" with a non-default value of "true" as per V$SQL_OPTIMIZER_ENV. Review the correctness of this non-default value "true" for SQL_ID gm7ak5qtcrd3m.
8 CBO PARAMETER _PGA_MAX_SIZE CBO initialization parameter "_pga_max_size" with a non-default value of "209700 KB" as per V$SQL_OPTIMIZER_ENV. Review the correctness of this non-default value "209700 KB" for SQL_ID gm7ak5qtcrd3m.
9 CBO PARAMETER _SORT_ELIMINATION_COST_RATIO CBO initialization parameter "_sort_elimination_cost_ratio" with a non-default value of "5" as per V$SQL_OPTIMIZER_ENV. Review the correctness of this non-default value "5" for SQL_ID gm7ak5qtcrd3m.
10 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.
11 MAT_VIEW REWRITE_ENABLED There are 34 materialized views with rewrite enabled. A large number of materialized views could affect parsing time since CBO would have to evaluate each during a hard-parse.
12 TABLE GL.GL_JE_LINES Table CBO statistics are 66 days old: 2013-07-20/02:36:05. Consider gathering fresh table statistics with a sample size of 3%.
Old statistics could contain low/high values for which a predicate may be out of range, producing then a poor plan.
13 TABLE GL.GL_JE_SEGMENT_VALUES Table CBO statistics are 66 days old: 2013-07-20/02:57:22. Consider gathering fresh table statistics with a sample size of 30%.
Old statistics could contain low/high values for which a predicate may be out of range, producing then a poor plan.
14 TABLE GL.GL_LEDGER_SEGMENT_VALUES Table CBO statistics are 66 days old: 2013-07-20/02:57:37. Consider gathering fresh table statistics with a sample size of 100%.
Old statistics could contain low/high values for which a predicate may be out of range, producing then a poor plan.

SQL Text

SELECT  nvl(count(*), :"SYS_B_00")
FROM gl_je_segment_values sv,
gl_je_lines jel,
gl_ledger_segment_values lsv
WHERE jel.je_header_id IN (:"SYS_B_01", :"SYS_B_02", :"SYS_B_03", :"SYS_B_04", :"SYS_B_05", :"SYS_B_06", :"SYS_B_07", :"SYS_B_08", :"SYS_B_09", :"SYS_B_10")
AND jel.je_line_num = :"SYS_B_11"
AND sv.je_header_id = jel.je_header_id
AND sv.segment_type_code = :"SYS_B_12"
AND lsv.ledger_id = :"SYS_B_13"
AND lsv.segment_type_code = :"SYS_B_14"
AND lsv.segment_value = sv.segment_value
AND jel.effective_date BETWEEN nvl(lsv.start_date, jel.effective_date - :"SYS_B_15") AND nvl(lsv.end_date, jel.effective_date + :"SYS_B_16")

Tables Summary

Values below have two purposes:
1. Provide a quick view of the state of Table level CBO statistics, as well as their indexes and columns.
2. Ease a compare between two systems that are believed to be similar.
# 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 GL_JE_LINES GL 180319420 178516226 20-JUL-13 02:36:05 5 134728769 94 0 75649495
2 GL_JE_SEGMENT_VALUES GL 5277538 5224763 20-JUL-13 02:57:22 1 5223640 8 0 5224763
3 GL_LEDGER_SEGMENT_VALUES GL 1017 1017 20-JUL-13 02:57:37 1 1017 14 0 1017

Indexes Summary

Values below have two purposes:
1. Provide a quick view of the state of Index level CBO statistics, as well as their columns.
2. Ease a compare between two systems that are believed to be similar.
# 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 GL_JE_LINES GL GL_JE_LINES_IDX1 GL YES YES 180296987 178494017 20-JUL-13 02:47:10 1 0 178516226
2 GL_JE_LINES GL GL_JE_LINES_N1 GL 180263964 178461324 20-JUL-13 02:53:57 2 0 178516226
3 GL_JE_LINES GL GL_JE_LINES_N3 GL 0 0 20-JUL-13 02:53:57 2 0
4 GL_JE_LINES GL GL_JE_LINES_N4 GL 139543913 138148474 20-JUL-13 02:42:36 3 0 138131076
5 GL_JE_LINES GL GL_JE_LINES_U1 GL 180343467 178540032 20-JUL-13 02:56:47 2 0 178516226
6 GL_JE_SEGMENT_VALUES GL GL_JE_SEGMENT_VALUES_U1 GL YES YES 5276404 5223640 20-JUL-13 02:57:28 3 0 5224763
7 GL_LEDGER_SEGMENT_VALUES GL GL_LEDGER_SEGMENT_VALUES_N1 GL YES YES 1017 1017 20-JUL-13 02:57:37 3 0 1017

Current SQL Statistics (GV$SQL)

Performance metrics of child cursors of gm7ak5qtcrd3m while still in memory.
# 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 2873749939 1 1 1 0 1 162401 160543 0 0 420.752 13.730 414.262 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 15 2693624943 APPS SQL*Plus 2013-09-18/14:39:49 2013-09-18/14:39:49 2013-09-18/14:47:00
2 1 1 2873749939 2 2 1 0 2 487712 477203 1 1 671.681 39.370 659.123 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 15 3723416719 APPS SQL*Plus 2013-09-18/14:39:49 2013-09-18/16:24:11 2013-09-18/16:40:33
3 1 2 2873749939 4 4 2 0 4 1371129 1319440 0 2 1605.859 95.710 1560.577 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 15 3723416719 SYS SQL*Plus 2013-09-18/14:39:49 2013-09-23/13:31:18 2013-09-23/16:16:00

Historical SQL Statistics (DBA_HIST_SQLSTAT)

Performance metrics of execution plans of gm7ak5qtcrd3m captured by AWR.
# 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
1 1265 2013-09-18/15:00:53 1 2873749939 1 1 1 1 0 1 162401 160543 0 0 420.752 13.730 414.262 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 15 2693624943 APPS SQL*Plus
2 1267 2013-09-18/17:00:03 1 2873749939 3 4 4 3 0 4 1132894 1105309 1 2 1659.310 86.540 1624.403 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 15 3723416719 APPS SQL*Plus
3 1384 2013-09-23/14:00:18 1 2873749939 3 6 6 4 0 6 1538461 1484808 1 2 2139.020 114.870 2090.664 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 15 3723416719 SYS SQL*Plus
4 1387 2013-09-23/17:00:30 1 2873749939 3 7 7 4 0 7 2021242 1957186 1 3 2698.292 148.810 2633.962 0.000 0.000 0.000 0.000 0.000 ALL_ROWS 15 3723416719 SYS SQL*Plus

Current Execution Plans (last execution)

Captured while still in memory. Metrics below are for the last execution of each child cursor.
If STATISTICS_LEVEL was set to ALL at the time of the hard-parse then A-Rows column is populated. 
Inst: 1   Child: 0    Plan hash value: 2873749939

                      ----------------------------------------------------------------------------------------------------------------
                      | Id  | Operation                       | Name                        | E-Rows |E-Bytes| Cost (%CPU)| E-Time   |
                      ----------------------------------------------------------------------------------------------------------------
                      |   0 | SELECT STATEMENT                |                             |        |       |    15 (100)|          |
                      |   1 |  SORT AGGREGATE                 |                             |      1 |    50 |            |          |
                      |   2 |   NESTED LOOPS                  |                             |        |       |            |          |
                      |   3 |    NESTED LOOPS                 |                             |      1 |    50 |    15   (0)| 00:00:01 |
                      |   4 |     NESTED LOOPS                |                             |      1 |    35 |    13   (0)| 00:00:01 |
                      |*  5 |      TABLE ACCESS BY INDEX ROWID| GL_JE_LINES                 |      1 |    20 |    11   (0)| 00:00:01 |
                      |*  6 |       INDEX RANGE SCAN          | GL_JE_LINES_IDX1            |      8 |       |     4   (0)| 00:00:01 |
                      |*  7 |      INDEX RANGE SCAN           | GL_JE_SEGMENT_VALUES_U1     |      1 |    15 |     2   (0)| 00:00:01 |
                      |*  8 |     INDEX RANGE SCAN            | GL_LEDGER_SEGMENT_VALUES_N1 |      1 |       |     1   (0)| 00:00:01 |
                      |*  9 |    TABLE ACCESS BY INDEX ROWID  | GL_LEDGER_SEGMENT_VALUES    |      1 |    15 |     2   (0)| 00:00:01 |
                      ----------------------------------------------------------------------------------------------------------------

                      Query Block Name / Object Alias (identified by operation id):
                      -------------------------------------------------------------

                         1 - SEL$1
                         5 - SEL$1 / JEL@SEL$1
                         6 - SEL$1 / JEL@SEL$1
                         7 - SEL$1 / SV@SEL$1
                         8 - SEL$1 / LSV@SEL$1
                         9 - SEL$1 / LSV@SEL$1

                      Outline Data
                      -------------

                        /*+
                            BEGIN_OUTLINE_DATA
                            IGNORE_OPTIM_EMBEDDED_HINTS
                            OPTIMIZER_FEATURES_ENABLE('11.1.0.7')
                            DB_VERSION('11.1.0.7')
                            OPT_PARAM('_b_tree_bitmap_plans' 'false')
                            OPT_PARAM('_fast_full_scan_enabled' 'false')
                            OPT_PARAM('_index_join_enabled' 'false')
                            ALL_ROWS
                            OUTLINE_LEAF(@"SEL$1")
                            INDEX_RS_ASC(@"SEL$1" "JEL"@"SEL$1" ("GL_JE_LINES"."JE_LINE_NUM"))
                            INDEX(@"SEL$1" "SV"@"SEL$1" ("GL_JE_SEGMENT_VALUES"."JE_HEADER_ID"
                                    "GL_JE_SEGMENT_VALUES"."SEGMENT_TYPE_CODE" "GL_JE_SEGMENT_VALUES"."SEGMENT_VALUE"))
                            INDEX(@"SEL$1" "LSV"@"SEL$1" ("GL_LEDGER_SEGMENT_VALUES"."LEDGER_ID"
                                    "GL_LEDGER_SEGMENT_VALUES"."SEGMENT_TYPE_CODE" "GL_LEDGER_SEGMENT_VALUES"."SEGMENT_VALUE"))
                            LEADING(@"SEL$1" "JEL"@"SEL$1" "SV"@"SEL$1" "LSV"@"SEL$1")
                            USE_NL(@"SEL$1" "SV"@"SEL$1")
                            USE_NL(@"SEL$1" "LSV"@"SEL$1")
                            NLJ_BATCHING(@"SEL$1" "LSV"@"SEL$1")
                            END_OUTLINE_DATA
                        */

                      Predicate Information (identified by operation id):
                      ---------------------------------------------------

                         5 - filter(("JEL"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_01) OR "JEL"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_02)
                                    OR "JEL"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_03) OR "JEL"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_04) OR
                                    "JEL"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_05) OR "JEL"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_06) OR
                                    "JEL"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_07) OR "JEL"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_08) OR
                                    "JEL"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_09) OR "JEL"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_10)))
                         6 - access("JEL"."JE_LINE_NUM"=:SYS_B_11)
                         7 - access("SV"."JE_HEADER_ID"="JEL"."JE_HEADER_ID" AND "SV"."SEGMENT_TYPE_CODE"=:SYS_B_12)
                             filter(("SV"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_01) OR "SV"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_02) OR
                                    "SV"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_03) OR "SV"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_04) OR
                                    "SV"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_05) OR "SV"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_06) OR
                                    "SV"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_07) OR "SV"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_08) OR
                                    "SV"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_09) OR "SV"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_10)))
                         8 - access("LSV"."LEDGER_ID"=:SYS_B_13 AND "LSV"."SEGMENT_TYPE_CODE"=:SYS_B_14 AND
                                    "LSV"."SEGMENT_VALUE"="SV"."SEGMENT_VALUE")
                         9 - filter(("JEL"."EFFECTIVE_DATE">=NVL("LSV"."START_DATE",INTERNAL_FUNCTION("JEL"."EFFECTIVE_DATE")-
                                    :SYS_B_15) AND "JEL"."EFFECTIVE_DATE"<=NVL("LSV"."END_DATE",INTERNAL_FUNCTION("JEL"."EFFECTIVE_DATE")+:S
                                    YS_B_16)))

                      Note
                      -----
                         - 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: 1    Plan hash value: 2873749939

                      ----------------------------------------------------------------------------------------------------------------
                      | Id  | Operation                       | Name                        | E-Rows |E-Bytes| Cost (%CPU)| E-Time   |
                      ----------------------------------------------------------------------------------------------------------------
                      |   0 | SELECT STATEMENT                |                             |        |       |    15 (100)|          |
                      |   1 |  SORT AGGREGATE                 |                             |      1 |    50 |            |          |
                      |   2 |   NESTED LOOPS                  |                             |        |       |            |          |
                      |   3 |    NESTED LOOPS                 |                             |      1 |    50 |    15   (0)| 00:00:01 |
                      |   4 |     NESTED LOOPS                |                             |      1 |    35 |    13   (0)| 00:00:01 |
                      |*  5 |      TABLE ACCESS BY INDEX ROWID| GL_JE_LINES                 |      1 |    20 |    11   (0)| 00:00:01 |
                      |*  6 |       INDEX RANGE SCAN          | GL_JE_LINES_IDX1            |      8 |       |     4   (0)| 00:00:01 |
                      |*  7 |      INDEX RANGE SCAN           | GL_JE_SEGMENT_VALUES_U1     |      1 |    15 |     2   (0)| 00:00:01 |
                      |*  8 |     INDEX RANGE SCAN            | GL_LEDGER_SEGMENT_VALUES_N1 |      1 |       |     1   (0)| 00:00:01 |
                      |*  9 |    TABLE ACCESS BY INDEX ROWID  | GL_LEDGER_SEGMENT_VALUES    |      1 |    15 |     2   (0)| 00:00:01 |
                      ----------------------------------------------------------------------------------------------------------------

                      Query Block Name / Object Alias (identified by operation id):
                      -------------------------------------------------------------

                         1 - SEL$1
                         5 - SEL$1 / JEL@SEL$1
                         6 - SEL$1 / JEL@SEL$1
                         7 - SEL$1 / SV@SEL$1
                         8 - SEL$1 / LSV@SEL$1
                         9 - SEL$1 / LSV@SEL$1

                      Outline Data
                      -------------

                        /*+
                            BEGIN_OUTLINE_DATA
                            IGNORE_OPTIM_EMBEDDED_HINTS
                            OPTIMIZER_FEATURES_ENABLE('11.1.0.7')
                            DB_VERSION('11.1.0.7')
                            OPT_PARAM('_b_tree_bitmap_plans' 'false')
                            OPT_PARAM('_fast_full_scan_enabled' 'false')
                            OPT_PARAM('_index_join_enabled' 'false')
                            ALL_ROWS
                            OUTLINE_LEAF(@"SEL$1")
                            INDEX_RS_ASC(@"SEL$1" "JEL"@"SEL$1" ("GL_JE_LINES"."JE_LINE_NUM"))
                            INDEX(@"SEL$1" "SV"@"SEL$1" ("GL_JE_SEGMENT_VALUES"."JE_HEADER_ID"
                                    "GL_JE_SEGMENT_VALUES"."SEGMENT_TYPE_CODE" "GL_JE_SEGMENT_VALUES"."SEGMENT_VALUE"))
                            INDEX(@"SEL$1" "LSV"@"SEL$1" ("GL_LEDGER_SEGMENT_VALUES"."LEDGER_ID"
                                    "GL_LEDGER_SEGMENT_VALUES"."SEGMENT_TYPE_CODE" "GL_LEDGER_SEGMENT_VALUES"."SEGMENT_VALUE"))
                            LEADING(@"SEL$1" "JEL"@"SEL$1" "SV"@"SEL$1" "LSV"@"SEL$1")
                            USE_NL(@"SEL$1" "SV"@"SEL$1")
                            USE_NL(@"SEL$1" "LSV"@"SEL$1")
                            NLJ_BATCHING(@"SEL$1" "LSV"@"SEL$1")
                            END_OUTLINE_DATA
                        */

                      Predicate Information (identified by operation id):
                      ---------------------------------------------------

                         5 - filter(("JEL"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_01) OR "JEL"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_02)
                                    OR "JEL"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_03) OR "JEL"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_04) OR
                                    "JEL"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_05) OR "JEL"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_06) OR
                                    "JEL"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_07) OR "JEL"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_08) OR
                                    "JEL"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_09) OR "JEL"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_10)))
                         6 - access("JEL"."JE_LINE_NUM"=:SYS_B_11)
                         7 - access("SV"."JE_HEADER_ID"="JEL"."JE_HEADER_ID" AND "SV"."SEGMENT_TYPE_CODE"=:SYS_B_12)
                             filter(("SV"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_01) OR "SV"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_02) OR
                                    "SV"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_03) OR "SV"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_04) OR
                                    "SV"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_05) OR "SV"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_06) OR
                                    "SV"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_07) OR "SV"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_08) OR
                                    "SV"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_09) OR "SV"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_10)))
                         8 - access("LSV"."LEDGER_ID"=:SYS_B_13 AND "LSV"."SEGMENT_TYPE_CODE"=:SYS_B_14 AND
                                    "LSV"."SEGMENT_VALUE"="SV"."SEGMENT_VALUE")
                         9 - filter(("JEL"."EFFECTIVE_DATE">=NVL("LSV"."START_DATE",INTERNAL_FUNCTION("JEL"."EFFECTIVE_DATE")-
                                    :SYS_B_15) AND "JEL"."EFFECTIVE_DATE"<=NVL("LSV"."END_DATE",INTERNAL_FUNCTION("JEL"."EFFECTIVE_DATE")+:S
                                    YS_B_16)))

                      Note
                      -----
                         - 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: 2    Plan hash value: 2873749939

                      ----------------------------------------------------------------------------------------------------------------
                      | Id  | Operation                       | Name                        | E-Rows |E-Bytes| Cost (%CPU)| E-Time   |
                      ----------------------------------------------------------------------------------------------------------------
                      |   0 | SELECT STATEMENT                |                             |        |       |    15 (100)|          |
                      |   1 |  SORT AGGREGATE                 |                             |      1 |    50 |            |          |
                      |   2 |   NESTED LOOPS                  |                             |        |       |            |          |
                      |   3 |    NESTED LOOPS                 |                             |      1 |    50 |    15   (0)| 00:00:01 |
                      |   4 |     NESTED LOOPS                |                             |      1 |    35 |    13   (0)| 00:00:01 |
                      |*  5 |      TABLE ACCESS BY INDEX ROWID| GL_JE_LINES                 |      1 |    20 |    11   (0)| 00:00:01 |
                      |*  6 |       INDEX RANGE SCAN          | GL_JE_LINES_IDX1            |      8 |       |     4   (0)| 00:00:01 |
                      |*  7 |      INDEX RANGE SCAN           | GL_JE_SEGMENT_VALUES_U1     |      1 |    15 |     2   (0)| 00:00:01 |
                      |*  8 |     INDEX RANGE SCAN            | GL_LEDGER_SEGMENT_VALUES_N1 |      1 |       |     1   (0)| 00:00:01 |
                      |*  9 |    TABLE ACCESS BY INDEX ROWID  | GL_LEDGER_SEGMENT_VALUES    |      1 |    15 |     2   (0)| 00:00:01 |
                      ----------------------------------------------------------------------------------------------------------------

                      Query Block Name / Object Alias (identified by operation id):
                      -------------------------------------------------------------

                         1 - SEL$1
                         5 - SEL$1 / JEL@SEL$1
                         6 - SEL$1 / JEL@SEL$1
                         7 - SEL$1 / SV@SEL$1
                         8 - SEL$1 / LSV@SEL$1
                         9 - SEL$1 / LSV@SEL$1

                      Outline Data
                      -------------

                        /*+
                            BEGIN_OUTLINE_DATA
                            IGNORE_OPTIM_EMBEDDED_HINTS
                            OPTIMIZER_FEATURES_ENABLE('11.1.0.7')
                            DB_VERSION('11.1.0.7')
                            OPT_PARAM('_b_tree_bitmap_plans' 'false')
                            OPT_PARAM('_fast_full_scan_enabled' 'false')
                            OPT_PARAM('_index_join_enabled' 'false')
                            ALL_ROWS
                            OUTLINE_LEAF(@"SEL$1")
                            INDEX_RS_ASC(@"SEL$1" "JEL"@"SEL$1" ("GL_JE_LINES"."JE_LINE_NUM"))
                            INDEX(@"SEL$1" "SV"@"SEL$1" ("GL_JE_SEGMENT_VALUES"."JE_HEADER_ID"
                                    "GL_JE_SEGMENT_VALUES"."SEGMENT_TYPE_CODE" "GL_JE_SEGMENT_VALUES"."SEGMENT_VALUE"))
                            INDEX(@"SEL$1" "LSV"@"SEL$1" ("GL_LEDGER_SEGMENT_VALUES"."LEDGER_ID"
                                    "GL_LEDGER_SEGMENT_VALUES"."SEGMENT_TYPE_CODE" "GL_LEDGER_SEGMENT_VALUES"."SEGMENT_VALUE"))
                            LEADING(@"SEL$1" "JEL"@"SEL$1" "SV"@"SEL$1" "LSV"@"SEL$1")
                            USE_NL(@"SEL$1" "SV"@"SEL$1")
                            USE_NL(@"SEL$1" "LSV"@"SEL$1")
                            NLJ_BATCHING(@"SEL$1" "LSV"@"SEL$1")
                            END_OUTLINE_DATA
                        */

                      Predicate Information (identified by operation id):
                      ---------------------------------------------------

                         5 - filter(("JEL"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_01) OR "JEL"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_02)
                                    OR "JEL"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_03) OR "JEL"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_04) OR
                                    "JEL"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_05) OR "JEL"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_06) OR
                                    "JEL"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_07) OR "JEL"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_08) OR
                                    "JEL"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_09) OR "JEL"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_10)))
                         6 - access("JEL"."JE_LINE_NUM"=:SYS_B_11)
                         7 - access("SV"."JE_HEADER_ID"="JEL"."JE_HEADER_ID" AND "SV"."SEGMENT_TYPE_CODE"=:SYS_B_12)
                             filter(("SV"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_01) OR "SV"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_02) OR
                                    "SV"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_03) OR "SV"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_04) OR
                                    "SV"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_05) OR "SV"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_06) OR
                                    "SV"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_07) OR "SV"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_08) OR
                                    "SV"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_09) OR "SV"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_10)))
                         8 - access("LSV"."LEDGER_ID"=:SYS_B_13 AND "LSV"."SEGMENT_TYPE_CODE"=:SYS_B_14 AND
                                    "LSV"."SEGMENT_VALUE"="SV"."SEGMENT_VALUE")
                         9 - filter(("JEL"."EFFECTIVE_DATE">=NVL("LSV"."START_DATE",INTERNAL_FUNCTION("JEL"."EFFECTIVE_DATE")-
                                    :SYS_B_15) AND "JEL"."EFFECTIVE_DATE"<=NVL("LSV"."END_DATE",INTERNAL_FUNCTION("JEL"."EFFECTIVE_DATE")+:S
                                    YS_B_16)))

                      Note
                      -----
                         - 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

Current Execution Plans (all executions)

Captured while still in memory. Metrics below are an aggregate for all the execution of each child cursor.
If STATISTICS_LEVEL was set to ALL at the time of the hard-parse then A-Rows column is populated. 
Inst: 1   Child: 1    Plan hash value: 2873749939

                      ----------------------------------------------------------------------------------------------------------------
                      | Id  | Operation                       | Name                        | E-Rows |E-Bytes| Cost (%CPU)| E-Time   |
                      ----------------------------------------------------------------------------------------------------------------
                      |   0 | SELECT STATEMENT                |                             |        |       |    15 (100)|          |
                      |   1 |  SORT AGGREGATE                 |                             |      1 |    50 |            |          |
                      |   2 |   NESTED LOOPS                  |                             |        |       |            |          |
                      |   3 |    NESTED LOOPS                 |                             |      1 |    50 |    15   (0)| 00:00:01 |
                      |   4 |     NESTED LOOPS                |                             |      1 |    35 |    13   (0)| 00:00:01 |
                      |*  5 |      TABLE ACCESS BY INDEX ROWID| GL_JE_LINES                 |      1 |    20 |    11   (0)| 00:00:01 |
                      |*  6 |       INDEX RANGE SCAN          | GL_JE_LINES_IDX1            |      8 |       |     4   (0)| 00:00:01 |
                      |*  7 |      INDEX RANGE SCAN           | GL_JE_SEGMENT_VALUES_U1     |      1 |    15 |     2   (0)| 00:00:01 |
                      |*  8 |     INDEX RANGE SCAN            | GL_LEDGER_SEGMENT_VALUES_N1 |      1 |       |     1   (0)| 00:00:01 |
                      |*  9 |    TABLE ACCESS BY INDEX ROWID  | GL_LEDGER_SEGMENT_VALUES    |      1 |    15 |     2   (0)| 00:00:01 |
                      ----------------------------------------------------------------------------------------------------------------

                      Query Block Name / Object Alias (identified by operation id):
                      -------------------------------------------------------------

                         1 - SEL$1
                         5 - SEL$1 / JEL@SEL$1
                         6 - SEL$1 / JEL@SEL$1
                         7 - SEL$1 / SV@SEL$1
                         8 - SEL$1 / LSV@SEL$1
                         9 - SEL$1 / LSV@SEL$1

                      Outline Data
                      -------------

                        /*+
                            BEGIN_OUTLINE_DATA
                            IGNORE_OPTIM_EMBEDDED_HINTS
                            OPTIMIZER_FEATURES_ENABLE('11.1.0.7')
                            DB_VERSION('11.1.0.7')
                            OPT_PARAM('_b_tree_bitmap_plans' 'false')
                            OPT_PARAM('_fast_full_scan_enabled' 'false')
                            OPT_PARAM('_index_join_enabled' 'false')
                            ALL_ROWS
                            OUTLINE_LEAF(@"SEL$1")
                            INDEX_RS_ASC(@"SEL$1" "JEL"@"SEL$1" ("GL_JE_LINES"."JE_LINE_NUM"))
                            INDEX(@"SEL$1" "SV"@"SEL$1" ("GL_JE_SEGMENT_VALUES"."JE_HEADER_ID"
                                    "GL_JE_SEGMENT_VALUES"."SEGMENT_TYPE_CODE" "GL_JE_SEGMENT_VALUES"."SEGMENT_VALUE"))
                            INDEX(@"SEL$1" "LSV"@"SEL$1" ("GL_LEDGER_SEGMENT_VALUES"."LEDGER_ID"
                                    "GL_LEDGER_SEGMENT_VALUES"."SEGMENT_TYPE_CODE" "GL_LEDGER_SEGMENT_VALUES"."SEGMENT_VALUE"))
                            LEADING(@"SEL$1" "JEL"@"SEL$1" "SV"@"SEL$1" "LSV"@"SEL$1")
                            USE_NL(@"SEL$1" "SV"@"SEL$1")
                            USE_NL(@"SEL$1" "LSV"@"SEL$1")
                            NLJ_BATCHING(@"SEL$1" "LSV"@"SEL$1")
                            END_OUTLINE_DATA
                        */

                      Predicate Information (identified by operation id):
                      ---------------------------------------------------

                         5 - filter(("JEL"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_01) OR "JEL"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_02)
                                    OR "JEL"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_03) OR "JEL"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_04) OR
                                    "JEL"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_05) OR "JEL"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_06) OR
                                    "JEL"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_07) OR "JEL"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_08) OR
                                    "JEL"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_09) OR "JEL"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_10)))
                         6 - access("JEL"."JE_LINE_NUM"=:SYS_B_11)
                         7 - access("SV"."JE_HEADER_ID"="JEL"."JE_HEADER_ID" AND "SV"."SEGMENT_TYPE_CODE"=:SYS_B_12)
                             filter(("SV"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_01) OR "SV"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_02) OR
                                    "SV"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_03) OR "SV"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_04) OR
                                    "SV"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_05) OR "SV"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_06) OR
                                    "SV"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_07) OR "SV"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_08) OR
                                    "SV"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_09) OR "SV"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_10)))
                         8 - access("LSV"."LEDGER_ID"=:SYS_B_13 AND "LSV"."SEGMENT_TYPE_CODE"=:SYS_B_14 AND
                                    "LSV"."SEGMENT_VALUE"="SV"."SEGMENT_VALUE")
                         9 - filter(("JEL"."EFFECTIVE_DATE">=NVL("LSV"."START_DATE",INTERNAL_FUNCTION("JEL"."EFFECTIVE_DATE")-
                                    :SYS_B_15) AND "JEL"."EFFECTIVE_DATE"<=NVL("LSV"."END_DATE",INTERNAL_FUNCTION("JEL"."EFFECTIVE_DATE")+:S
                                    YS_B_16)))

                      Note
                      -----
                         - 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: 2    Plan hash value: 2873749939

                      ----------------------------------------------------------------------------------------------------------------
                      | Id  | Operation                       | Name                        | E-Rows |E-Bytes| Cost (%CPU)| E-Time   |
                      ----------------------------------------------------------------------------------------------------------------
                      |   0 | SELECT STATEMENT                |                             |        |       |    15 (100)|          |
                      |   1 |  SORT AGGREGATE                 |                             |      1 |    50 |            |          |
                      |   2 |   NESTED LOOPS                  |                             |        |       |            |          |
                      |   3 |    NESTED LOOPS                 |                             |      1 |    50 |    15   (0)| 00:00:01 |
                      |   4 |     NESTED LOOPS                |                             |      1 |    35 |    13   (0)| 00:00:01 |
                      |*  5 |      TABLE ACCESS BY INDEX ROWID| GL_JE_LINES                 |      1 |    20 |    11   (0)| 00:00:01 |
                      |*  6 |       INDEX RANGE SCAN          | GL_JE_LINES_IDX1            |      8 |       |     4   (0)| 00:00:01 |
                      |*  7 |      INDEX RANGE SCAN           | GL_JE_SEGMENT_VALUES_U1     |      1 |    15 |     2   (0)| 00:00:01 |
                      |*  8 |     INDEX RANGE SCAN            | GL_LEDGER_SEGMENT_VALUES_N1 |      1 |       |     1   (0)| 00:00:01 |
                      |*  9 |    TABLE ACCESS BY INDEX ROWID  | GL_LEDGER_SEGMENT_VALUES    |      1 |    15 |     2   (0)| 00:00:01 |
                      ----------------------------------------------------------------------------------------------------------------

                      Query Block Name / Object Alias (identified by operation id):
                      -------------------------------------------------------------

                         1 - SEL$1
                         5 - SEL$1 / JEL@SEL$1
                         6 - SEL$1 / JEL@SEL$1
                         7 - SEL$1 / SV@SEL$1
                         8 - SEL$1 / LSV@SEL$1
                         9 - SEL$1 / LSV@SEL$1

                      Outline Data
                      -------------

                        /*+
                            BEGIN_OUTLINE_DATA
                            IGNORE_OPTIM_EMBEDDED_HINTS
                            OPTIMIZER_FEATURES_ENABLE('11.1.0.7')
                            DB_VERSION('11.1.0.7')
                            OPT_PARAM('_b_tree_bitmap_plans' 'false')
                            OPT_PARAM('_fast_full_scan_enabled' 'false')
                            OPT_PARAM('_index_join_enabled' 'false')
                            ALL_ROWS
                            OUTLINE_LEAF(@"SEL$1")
                            INDEX_RS_ASC(@"SEL$1" "JEL"@"SEL$1" ("GL_JE_LINES"."JE_LINE_NUM"))
                            INDEX(@"SEL$1" "SV"@"SEL$1" ("GL_JE_SEGMENT_VALUES"."JE_HEADER_ID"
                                    "GL_JE_SEGMENT_VALUES"."SEGMENT_TYPE_CODE" "GL_JE_SEGMENT_VALUES"."SEGMENT_VALUE"))
                            INDEX(@"SEL$1" "LSV"@"SEL$1" ("GL_LEDGER_SEGMENT_VALUES"."LEDGER_ID"
                                    "GL_LEDGER_SEGMENT_VALUES"."SEGMENT_TYPE_CODE" "GL_LEDGER_SEGMENT_VALUES"."SEGMENT_VALUE"))
                            LEADING(@"SEL$1" "JEL"@"SEL$1" "SV"@"SEL$1" "LSV"@"SEL$1")
                            USE_NL(@"SEL$1" "SV"@"SEL$1")
                            USE_NL(@"SEL$1" "LSV"@"SEL$1")
                            NLJ_BATCHING(@"SEL$1" "LSV"@"SEL$1")
                            END_OUTLINE_DATA
                        */

                      Predicate Information (identified by operation id):
                      ---------------------------------------------------

                         5 - filter(("JEL"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_01) OR "JEL"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_02)
                                    OR "JEL"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_03) OR "JEL"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_04) OR
                                    "JEL"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_05) OR "JEL"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_06) OR
                                    "JEL"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_07) OR "JEL"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_08) OR
                                    "JEL"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_09) OR "JEL"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_10)))
                         6 - access("JEL"."JE_LINE_NUM"=:SYS_B_11)
                         7 - access("SV"."JE_HEADER_ID"="JEL"."JE_HEADER_ID" AND "SV"."SEGMENT_TYPE_CODE"=:SYS_B_12)
                             filter(("SV"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_01) OR "SV"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_02) OR
                                    "SV"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_03) OR "SV"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_04) OR
                                    "SV"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_05) OR "SV"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_06) OR
                                    "SV"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_07) OR "SV"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_08) OR
                                    "SV"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_09) OR "SV"."JE_HEADER_ID"=TO_NUMBER(:SYS_B_10)))
                         8 - access("LSV"."LEDGER_ID"=:SYS_B_13 AND "LSV"."SEGMENT_TYPE_CODE"=:SYS_B_14 AND
                                    "LSV"."SEGMENT_VALUE"="SV"."SEGMENT_VALUE")
                         9 - filter(("JEL"."EFFECTIVE_DATE">=NVL("LSV"."START_DATE",INTERNAL_FUNCTION("JEL"."EFFECTIVE_DATE")-
                                    :SYS_B_15) AND "JEL"."EFFECTIVE_DATE"<=NVL("LSV"."END_DATE",INTERNAL_FUNCTION("JEL"."EFFECTIVE_DATE")+:S
                                    YS_B_16)))

                      Note
                      -----
                         - 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

Historical Execution Plans

Captured by AWR. 
SQL_ID gm7ak5qtcrd3m
--------------------
SELECT  nvl(count(*), :"SYS_B_00")   FROM gl_je_segment_values sv,
  gl_je_lines jel,        gl_ledger_segment_values lsv  WHERE
jel.je_header_id IN (:"SYS_B_01", :"SYS_B_02", :"SYS_B_03",
:"SYS_B_04", :"SYS_B_05", :"SYS_B_06", :"SYS_B_07", :"SYS_B_08",
:"SYS_B_09", :"SYS_B_10")    AND jel.je_line_num = :"SYS_B_11"    AND
sv.je_header_id = jel.je_header_id    AND sv.segment_type_code =
:"SYS_B_12"    AND lsv.ledger_id = :"SYS_B_13"    AND
lsv.segment_type_code = :"SYS_B_14"    AND lsv.segment_value =
sv.segment_value    AND jel.effective_date BETWEEN nvl(lsv.start_date,
jel.effective_date - :"SYS_B_15") AND nvl(lsv.end_date,
jel.effective_date + :"SYS_B_16")

Plan hash value: 2873749939

---------------------------------------------------------------------------------------------------------------
| Id  | Operation                       | Name                        | Rows  | Bytes | Cost (%CPU)| Time     |
---------------------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT                |                             |       |       |    15 (100)|          |
|   1 |  SORT AGGREGATE                 |                             |     1 |    50 |            |          |
|   2 |   NESTED LOOPS                  |                             |       |       |            |          |
|   3 |    NESTED LOOPS                 |                             |     1 |    50 |    15   (0)| 00:00:01 |
|   4 |     NESTED LOOPS                |                             |     1 |    35 |    13   (0)| 00:00:01 |
|   5 |      TABLE ACCESS BY INDEX ROWID| GL_JE_LINES                 |     1 |    20 |    11   (0)| 00:00:01 |
|   6 |       INDEX RANGE SCAN          | GL_JE_LINES_IDX1            |     8 |       |     4   (0)| 00:00:01 |
|   7 |      INDEX RANGE SCAN           | GL_JE_SEGMENT_VALUES_U1     |     1 |    15 |     2   (0)| 00:00:01 |
|   8 |     INDEX RANGE SCAN            | GL_LEDGER_SEGMENT_VALUES_N1 |     1 |       |     1   (0)| 00:00:01 |
|   9 |    TABLE ACCESS BY INDEX ROWID  | GL_LEDGER_SEGMENT_VALUES    |     1 |    15 |     2   (0)| 00:00:01 |
---------------------------------------------------------------------------------------------------------------

Query Block Name / Object Alias (identified by operation id):
-------------------------------------------------------------

   1 - SEL$1
   5 - SEL$1 / JEL@SEL$1
   6 - SEL$1 / JEL@SEL$1
   7 - SEL$1 / SV@SEL$1
   8 - SEL$1 / LSV@SEL$1
   9 - SEL$1 / LSV@SEL$1

Outline Data
-------------

  /*+
      BEGIN_OUTLINE_DATA
      IGNORE_OPTIM_EMBEDDED_HINTS
      OPTIMIZER_FEATURES_ENABLE('11.1.0.7')
      DB_VERSION('11.1.0.7')
      OPT_PARAM('_b_tree_bitmap_plans' 'false')
      OPT_PARAM('_fast_full_scan_enabled' 'false')
      OPT_PARAM('_index_join_enabled' 'false')
      ALL_ROWS
      OUTLINE_LEAF(@"SEL$1")
      INDEX_RS_ASC(@"SEL$1" "JEL"@"SEL$1" ("GL_JE_LINES"."JE_LINE_NUM"))
      INDEX(@"SEL$1" "SV"@"SEL$1" ("GL_JE_SEGMENT_VALUES"."JE_HEADER_ID"
              "GL_JE_SEGMENT_VALUES"."SEGMENT_TYPE_CODE" "GL_JE_SEGMENT_VALUES"."SEGMENT_VALUE"))
      INDEX(@"SEL$1" "LSV"@"SEL$1" ("GL_LEDGER_SEGMENT_VALUES"."LEDGER_ID"
              "GL_LEDGER_SEGMENT_VALUES"."SEGMENT_TYPE_CODE" "GL_LEDGER_SEGMENT_VALUES"."SEGMENT_VALUE"))
      LEADING(@"SEL$1" "JEL"@"SEL$1" "SV"@"SEL$1" "LSV"@"SEL$1")
      USE_NL(@"SEL$1" "SV"@"SEL$1")
      USE_NL(@"SEL$1" "LSV"@"SEL$1")
      NLJ_BATCHING(@"SEL$1" "LSV"@"SEL$1")
      END_OUTLINE_DATA
  */
1366133.1 SQLHC 11.4.4.1 2013-09-24/13:33:24