-
Why it is not using PARALLEL hint with only this query?
Hi,
We are using PARALLEL hint very regularly. But, for some reason, it is not using PARALLEL hint only for the following query.
SELECT /*+ PARALLEL(glcc,6) */
glcc.segment3 A_ARC,
glcc.segment1 Fund,
tl.hierarchy_name Begin_Line,
SUBSTR(l.attribute9,1,4),
glcc.segment2 ,
0 Budget,
0,
0,
0,
(DECODE(NVL(SUBSTR(l.attribute9,5,1),glp.quarter_num),'1',NVL(l.accounted_dr,0) - NVL(l.accounted_cr,0))) Exp_Quarter1,
(DECODE(NVL(SUBSTR(l.attribute9,5,1),glp.quarter_num),'2',NVL(l.accounted_dr,0) - NVL(l.accounted_cr,0))) Exp_Quarter2,
(DECODE(NVL(SUBSTR(l.attribute9,5,1),glp.quarter_num),'3',NVL(l.accounted_dr,0) - NVL(l.accounted_cr,0))) Exp_Quarter3,
(DECODE(NVL(SUBSTR(l.attribute9,5,1),glp.quarter_num),'4',NVL(l.accounted_dr,0) - NVL(l.accounted_cr,0))) Exp_Quarter4,
0,0,0,0
FROM gl_je_lines l,
gl_je_headers h,
gl_code_combinations glcc,
gl_periods glp
,fnd_flex_value_hierarchies f
,fnd_flex_values v
,fnd_flex_hierarchies_tl tl
WHERE
glcc.code_combination_id = l.code_combination_id
and glcc.chart_of_accounts_id = :chart_of_Accounts_id
and glcc.segment10 NOT LIKE 'ZZ%'
AND glcc.segment2 BETWEEN f.child_flex_value_low AND f.child_flex_value_high
AND glcc.summary_flag = 'N'
AND f.flex_value_set_id = :sac_value_Set_id
AND f.parent_flex_value = v.flex_value
AND v.flex_value_set_id = :sac_value_set_id
AND v.summary_flag = 'Y'
AND v.structured_hierarchy_level = tl.hierarchy_id
AND tl.hierarchy_name LIKE '%-%'
AND l.period_name = glp.period_name
AND (
(glp.period_year = :fiscal_year AND :fiscal_year = eriod_year AND glp.period_num <= :begin_num)
OR
-- newly added for different year logic
(TRUNC(l.effective_date) BETWEEN '01-JUL-'||TO_CHAR(TO_DATE(:P_EXPENDITURE_DATE),'YY') AND '01-'||TO_CHAR(TO_DATE(:P_EXPENDITURE_DATE),'MON-YY'))
)
AND SUBSTR(l.attribute9,1,4) = :fiscal_year -- BUDGET YEAR
AND l.je_header_id = h.je_header_id
AND h.actual_Flag IN ('A')
AND h.je_source IN ('1','Manual','Spreadsheet')
If I simply use PARALLEL hint in say
select /*+ PARALLEL(glcc,6) */ segment2 from gl_code_combinations glcc
then, it shows PARALLEL operation in its Explain Plan.
Pl. advise.
Thanks,
Sam
------------------------
To handle yourself, use your head. To handle others, use your heart
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|