Why it is not using PARALLEL hint with only this query? - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

Thread: Why it is not using PARALLEL hint with only this query?

  1. #11
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Add a hint /*+ INDEX(GLCC) */ and post the explain plan here.

    Tamil

  2. #12
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    pobably resource manager is on

  3. #13
    Join Date
    Dec 2001
    Location
    USA
    Posts
    620
    Originally posted by tamilselvan
    Add a hint /*+ INDEX(GLCC) */ and post the explain plan here.

    Tamil
    Here it is. Pl. note that cost has increased 3 folds.

    Operation Object Name Rows Bytes Cost Object Node In/Out PStart PStop

    SELECT STATEMENT Hint=CHOOSE 1 10084
    NESTED LOOPS 1 145 10084
    HASH JOIN 1 134 10082
    TABLE ACCESS FULL GL_PERIODS 260 4 K 4
    NESTED LOOPS 227 25 K 10077
    NESTED LOOPS 226 17 K 7365
    NESTED LOOPS 3 144 15
    HASH JOIN 1 27 14
    TABLE ACCESS FULL FND_FLEX_HIERARCHIES_TL 34 374 5
    TABLE ACCESS BY INDEX ROWID FND_FLEX_VALUES 87 1 K 8
    INDEX RANGE SCAN FND_FLEX_VALUES_N3 87 1
    INDEX RANGE SCAN FND_FLEX_VALUE_HIERARCHIES_N1 335 6 K 1
    TABLE ACCESS BY INDEX ROWID GL_CODE_COMBINATIONS 30 K 884 K 2450
    INDEX RANGE SCAN GL_CODE_COMBINATIONS_N2 30 K 29
    TABLE ACCESS BY INDEX ROWID GL_JE_LINES 30 K 1 M 12
    INDEX RANGE SCAN GL_JE_LINES_N1 30 K 2
    TABLE ACCESS BY INDEX ROWID GL_JE_HEADERS 150 K 1 M 2
    INDEX UNIQUE SCAN GL_JE_HEADERS_U1 150 K 1
    Thanks,
    Sam
    ------------------------
    To handle yourself, use your head. To handle others, use your heart

  4. #14
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    I never tune a query by seeing the cost. I don't care about it b/c of the bugs invloved in the CBO.

    I tune queries by reducing the LOG IOs only.

    After adding the hint, Does the total logical IOs come down or increase?

    Tamil

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width