1 2 3 Previous Next 31 Replies Latest reply: Dec 7, 2012 2:52 PM by 940856 Go to original post RSS
      • 15. Re: Parallel Query
        905562
        Check index CMR_UN01.

        It's not listed above, but it is in the plan.
        • 16. Re: Parallel Query
          940856
          SQL> select index_name, degree from dba_indexes where index_name in ('CMR_UN01');
          
          INDEX_NAME
          --------------------------------------------------------------------------------------
          DEGREE
          --------------------------------------------------------------------------------------
          CMR_UN01
          DEFAULT
          • 17. Re: Parallel Query
            905562
            There's your problem.

            Default is cpu count * parallel threads per CPU.


            If that's not meant to be parallel, turn it off. If it is, either hint the query to no_parallel or to not use that index.

            Indexes keep a hold of parallel settings after some maintenance operations are carried out in parallel. Quite common for folks to forget to take it back off.

            Edited by: mrk - typos

            Edited by: mrk on Dec 7, 2012 3:37 PM

            Edited by: mrk on Dec 7, 2012 3:37 PM
            • 18. Re: Parallel Query
              VijayaraghavanKrishnan
              Hi,


              The default means that whenever you do a full-scan on the table, it will be parallelized, to the number defined b y "degree". Change it your problem will be resolved.

              Thanks,
              Vijay

              Edited by: Vijayaraghavan Krishnan on Dec 7, 2012 9:47 AM

              Edited by: Vijayaraghavan Krishnan on Dec 7, 2012 9:48 AM
              • 19. Re: Parallel Query
                940856
                Still not out of the wood.
                SQL> alter index rds.CMR_UN01 parallel (degree 1);
                
                Index altered.
                
                SQL>  alter system flush shared_pool;
                
                System altered.
                
                SQL> explain plan for
                  2      SELECT SUM(IMC.TYPICAL_PERCENT)   TYPICAL_PERCENT
                  3            FROM rds.ITEM_MASTER_COMPONENT   IMC,
                  4                 rds.master_formula          frm
                  5      WHERE FRM.FRM_ID = 2060055 AND
                                 IMC.IML_ID = FRM.IML_ID AND
                  6    7                 EXISTS (SELECT 'X' FROM DUAL WHERE
                  8                         IMC.CMP_ID in (select cmp_id
                  9                                from rds.component_regulation cmr, rds.regulatory_application rap
                 10                             where cmr.rap_id = rap.rap_id
                 11                             and rap.procedure_name = 'CHALLENGE_USA_HYDROCARBON')) AND
                 12              frm.iml_id IS NOT NULL
                 13  /
                
                Explained.
                
                SQL> select * from table (dbms_xplan.display);
                
                PLAN_TABLE_OUTPUT
                -------------------------------------------------------------------------------------------------------------------------------------------------------------
                -------------------------------------------
                Plan hash value: 1894673998
                
                ---------------------------------------------------------------------------------------------------------------------------------------------------
                | Id  | Operation                            | Name                          | Rows  | Bytes | Cost (%CPU)| Time     |    TQ  |IN-OUT| PQ Distrib |
                ---------------------------------------------------------------------------------------------------------------------------------------------------
                |   0 | SELECT STATEMENT                     |                               |     1 |    37 |    18  (12)| 00:00:01 |        |      |            |
                |   1 |  SORT AGGREGATE                      |                               |     1 |    37 |            |          |        |      |            |
                |   2 |   PX COORDINATOR                     |                               |       |       |            |          |        |      |            |
                |   3 |    PX SEND QC (RANDOM)               | :TQ10004                      |     1 |    37 |            |          |  Q1,04 | P->S | QC (RAND)  |
                |   4 |     SORT AGGREGATE                   |                               |     1 |    37 |            |          |  Q1,04 | PCWP |            |
                |*  5 |      HASH JOIN SEMI                  |                               |     1 |    37 |    18  (12)| 00:00:01 |  Q1,04 | PCWP |            |
                |   6 |       BUFFER SORT                    |                               |       |       |            |          |  Q1,04 | PCWC |            |
                |   7 |        PX RECEIVE                    |                               |    21 |   504 |     8   (0)| 00:00:01 |  Q1,04 | PCWP |            |
                |   8 |         PX SEND HASH                 | :TQ10002                      |    21 |   504 |     8   (0)| 00:00:01 |        | S->P | HASH       |
                |   9 |          NESTED LOOPS                |                               |    21 |   504 |     8   (0)| 00:00:01 |        |      |            |
                |* 10 |           TABLE ACCESS BY INDEX ROWID| MASTER_FORMULA                |     1 |     8 |     3   (0)| 00:00:01 |        |      |            |
                |* 11 |            INDEX UNIQUE SCAN         | FRM_PK00                      |     1 |       |     2   (0)| 00:00:01 |        |      |            |
                |  12 |           TABLE ACCESS BY INDEX ROWID| ITEM_MASTER_COMPONENT         |    21 |   336 |     5   (0)| 00:00:01 |        |      |            |
                |* 13 |            INDEX RANGE SCAN          | ITEM_MASTER_COMPONENT_NDX_N01 |    21 |       |     2   (0)| 00:00:01 |        |      |            |
                |  14 |       PX RECEIVE                     |                               |   115 |  1495 |    37  (79)| 00:00:01 |  Q1,04 | PCWP |            |
                |  15 |        PX SEND HASH                  | :TQ10003                      |   115 |  1495 |    37  (79)| 00:00:01 |  Q1,03 | P->P | HASH       |
                |  16 |         VIEW                         | VW_SQ_1                       |   115 |  1495 |    37  (79)| 00:00:01 |  Q1,03 | PCWP |            |
                |  17 |          MERGE JOIN                  |                               |   115 |  2645 |    37   (9)| 00:00:01 |  Q1,03 | PCWP |            |
                |  18 |           SORT JOIN                  |                               | 29662 |   347K|    33   (7)| 00:00:01 |  Q1,03 | PCWP |            |
                |  19 |            NESTED LOOPS              |                               | 29662 |   347K|    31   (0)| 00:00:01 |  Q1,03 | PCWP |            |
                |  20 |             BUFFER SORT              |                               |       |       |            |          |  Q1,03 | PCWC |            |
                |  21 |              PX RECEIVE              |                               |       |       |            |          |  Q1,03 | PCWP |            |
                |  22 |               PX SEND BROADCAST      | :TQ10000                      |       |       |            |          |        | S->P | BROADCAST  |
                |  23 |                FAST DUAL             |                               |     1 |       |     2   (0)| 00:00:01 |        |      |            |
                |  24 |             PX BLOCK ITERATOR        |                               | 29662 |   347K|    29   (0)| 00:00:01 |  Q1,03 | PCWC |            |
                |  25 |              INDEX FAST FULL SCAN    | CMR_UN01                      | 29662 |   347K|    29   (0)| 00:00:01 |  Q1,03 | PCWP |            |
                |* 26 |           SORT JOIN                  |                               |     1 |    11 |     4  (25)| 00:00:01 |  Q1,03 | PCWP |            |
                |  27 |            BUFFER SORT               |                               |       |       |            |          |  Q1,03 | PCWC |            |
                |  28 |             PX RECEIVE               |                               |     1 |    11 |     3   (0)| 00:00:01 |  Q1,03 | PCWP |            |
                |  29 |              PX SEND BROADCAST       | :TQ10001                      |     1 |    11 |     3   (0)| 00:00:01 |        | S->P | BROADCAST  |
                |* 30 |               TABLE ACCESS FULL      | REGULATORY_APPLICATION        |     1 |    11 |     3   (0)| 00:00:01 |        |      |            |
                ---------------------------------------------------------------------------------------------------------------------------------------------------
                
                Predicate Information (identified by operation id):
                ---------------------------------------------------
                
                   5 - access("IMC"."CMP_ID"="ITEM_1")
                  10 - filter("FRM"."IML_ID" IS NOT NULL)
                  11 - access("FRM"."FRM_ID"=2060055)
                  13 - access("IMC"."IML_ID"="FRM"."IML_ID")
                  26 - access("CMR"."RAP_ID"="RAP"."RAP_ID")
                       filter("CMR"."RAP_ID"="RAP"."RAP_ID")
                  30 - filter("RAP"."PROCEDURE_NAME"='CHALLENGE_USA_HYDROCARBON')
                • 20. Re: Parallel Query
                  VijayaraghavanKrishnan
                  Hi,

                  Disable the parallel for the session and get the explain plan, we can eliminate one the whether it is set at session level
                  alter session disable parallel query;
                  Thanks,
                  Vijay
                  • 21. Re: Parallel Query
                    940856
                    Excellent!! it now not using parallelism. still wondering , I did not enable parallelism explicitly , yet oracle using it by default, is there any parameter, which we can turn on off to take away this behavior. we just don't need this by default.
                    excellent work for all :)
                    SQL> alter session disable parallel query;
                    
                    Session altered.
                    
                    SQL> 
                    SQL> explain plan for
                      2      SELECT SUM(IMC.TYPICAL_PERCENT)   TYPICAL_PERCENT
                      3            FROM rds.ITEM_MASTER_COMPONENT   IMC,
                      4                 rds.master_formula          frm
                      5      WHERE FRM.FRM_ID = 2060055 AND
                      6                   IMC.IML_ID = FRM.IML_ID AND
                      7                 EXISTS (SELECT 'X' FROM DUAL WHERE
                      8                         IMC.CMP_ID in (select cmp_id
                      9                                from rds.component_regulation cmr, rds.regulatory_application rap
                     10                             where cmr.rap_id = rap.rap_id
                     11                             and rap.procedure_name = 'CHALLENGE_USA_HYDROCARBON')) AND
                     12              frm.iml_id IS NOT NULL
                     13  /
                    
                    Explained.
                    
                    SQL>  select * from table (dbms_xplan.display);
                    
                    PLAN_TABLE_OUTPUT
                    -------------------------------------------------------------------------------------------------------------------------------------------------------------
                    -------------------------------------------
                    Plan hash value: 890648619
                    
                    ----------------------------------------------------------------------------------------------------------------
                    | Id  | Operation                      | Name                          | Rows  | Bytes | Cost (%CPU)| Time     |
                    ----------------------------------------------------------------------------------------------------------------
                    |   0 | SELECT STATEMENT               |                               |     1 |    37 |    43   (3)| 00:00:01 |
                    |   1 |  SORT AGGREGATE                |                               |     1 |    37 |            |          |
                    |*  2 |   HASH JOIN SEMI               |                               |     1 |    37 |    43   (3)| 00:00:01 |
                    |   3 |    NESTED LOOPS                |                               |    21 |   504 |     8   (0)| 00:00:01 |
                    |*  4 |     TABLE ACCESS BY INDEX ROWID| MASTER_FORMULA                |     1 |     8 |     3   (0)| 00:00:01 |
                    |*  5 |      INDEX UNIQUE SCAN         | FRM_PK00                      |     1 |       |     2   (0)| 00:00:01 |
                    |   6 |     TABLE ACCESS BY INDEX ROWID| ITEM_MASTER_COMPONENT         |    21 |   336 |     5   (0)| 00:00:01 |
                    |*  7 |      INDEX RANGE SCAN          | ITEM_MASTER_COMPONENT_NDX_N01 |    21 |       |     2   (0)| 00:00:01 |
                    |   8 |    VIEW                        | VW_SQ_1                       |   115 |  1495 |    35   (3)| 00:00:01 |
                    |*  9 |     HASH JOIN                  |                               |   115 |  2645 |    35   (3)| 00:00:01 |
                    |  10 |      NESTED LOOPS              |                               |     1 |    11 |     5   (0)| 00:00:01 |
                    |  11 |       FAST DUAL                |                               |     1 |       |     2   (0)| 00:00:01 |
                    |* 12 |       TABLE ACCESS FULL        | REGULATORY_APPLICATION        |     1 |    11 |     3   (0)| 00:00:01 |
                    |  13 |      INDEX FAST FULL SCAN      | CMR_UN01                      | 29662 |   347K|    29   (0)| 00:00:01 |
                    ----------------------------------------------------------------------------------------------------------------
                    
                    Predicate Information (identified by operation id):
                    ---------------------------------------------------
                    
                       2 - access("IMC"."CMP_ID"="ITEM_1")
                       4 - filter("FRM"."IML_ID" IS NOT NULL)
                       5 - access("FRM"."FRM_ID"=2060055)
                       7 - access("IMC"."IML_ID"="FRM"."IML_ID")
                       9 - access("CMR"."RAP_ID"="RAP"."RAP_ID")
                      12 - filter("RAP"."PROCEDURE_NAME"='CHALLENGE_USA_HYDROCARBON')
                    
                    30 rows selected.
                    
                    SQL>  alter session enable parallel query;
                    
                    Session altered.
                    
                    SQL> explain plan for
                      2      SELECT SUM(IMC.TYPICAL_PERCENT)   TYPICAL_PERCENT
                              FROM rds.ITEM_MASTER_COMPONENT   IMC,
                                   rds.master_formula          frm
                      3    4    5      WHERE FRM.FRM_ID = 2060055 AND
                      6                   IMC.IML_ID = FRM.IML_ID AND
                                   EXISTS (SELECT 'X' FROM DUAL WHERE
                      7    8                         IMC.CMP_ID in (select cmp_id
                      9                                from rds.component_regulation cmr, rds.regulatory_application rap
                     10                             where cmr.rap_id = rap.rap_id
                                               and rap.procedure_name = 'CHALLENGE_USA_HYDROCARBON')) AND
                     11   12              frm.iml_id IS NOT NULL
                     13  /
                    
                    Explained.
                    
                    SQL> select * from table (dbms_xplan.display);
                    
                    PLAN_TABLE_OUTPUT
                    -------------------------------------------------------------------------------------------------------------------------------------------------------------
                    -------------------------------------------
                    Plan hash value: 1894673998
                    
                    ---------------------------------------------------------------------------------------------------------------------------------------------------
                    | Id  | Operation                            | Name                          | Rows  | Bytes | Cost (%CPU)| Time     |    TQ  |IN-OUT| PQ Distrib |
                    ---------------------------------------------------------------------------------------------------------------------------------------------------
                    |   0 | SELECT STATEMENT                     |                               |     1 |    37 |    18  (12)| 00:00:01 |        |      |            |
                    |   1 |  SORT AGGREGATE                      |                               |     1 |    37 |            |          |        |      |            |
                    |   2 |   PX COORDINATOR                     |                               |       |       |            |          |        |      |            |
                    |   3 |    PX SEND QC (RANDOM)               | :TQ10004                      |     1 |    37 |            |          |  Q1,04 | P->S | QC (RAND)  |
                    |   4 |     SORT AGGREGATE                   |                               |     1 |    37 |            |          |  Q1,04 | PCWP |            |
                    |*  5 |      HASH JOIN SEMI                  |                               |     1 |    37 |    18  (12)| 00:00:01 |  Q1,04 | PCWP |            |
                    |   6 |       BUFFER SORT                    |                               |       |       |            |          |  Q1,04 | PCWC |            |
                    |   7 |        PX RECEIVE                    |                               |    21 |   504 |     8   (0)| 00:00:01 |  Q1,04 | PCWP |            |
                    |   8 |         PX SEND HASH                 | :TQ10002                      |    21 |   504 |     8   (0)| 00:00:01 |        | S->P | HASH       |
                    |   9 |          NESTED LOOPS                |                               |    21 |   504 |     8   (0)| 00:00:01 |        |      |            |
                    |* 10 |           TABLE ACCESS BY INDEX ROWID| MASTER_FORMULA                |     1 |     8 |     3   (0)| 00:00:01 |        |      |            |
                    |* 11 |            INDEX UNIQUE SCAN         | FRM_PK00                      |     1 |       |     2   (0)| 00:00:01 |        |      |            |
                    |  12 |           TABLE ACCESS BY INDEX ROWID| ITEM_MASTER_COMPONENT         |    21 |   336 |     5   (0)| 00:00:01 |        |      |            |
                    |* 13 |            INDEX RANGE SCAN          | ITEM_MASTER_COMPONENT_NDX_N01 |    21 |       |     2   (0)| 00:00:01 |        |      |            |
                    |  14 |       PX RECEIVE                     |                               |   115 |  1495 |    37  (79)| 00:00:01 |  Q1,04 | PCWP |            |
                    |  15 |        PX SEND HASH                  | :TQ10003                      |   115 |  1495 |    37  (79)| 00:00:01 |  Q1,03 | P->P | HASH       |
                    |  16 |         VIEW                         | VW_SQ_1                       |   115 |  1495 |    37  (79)| 00:00:01 |  Q1,03 | PCWP |            |
                    |  17 |          MERGE JOIN                  |                               |   115 |  2645 |    37   (9)| 00:00:01 |  Q1,03 | PCWP |            |
                    |  18 |           SORT JOIN                  |                               | 29662 |   347K|    33   (7)| 00:00:01 |  Q1,03 | PCWP |            |
                    |  19 |            NESTED LOOPS              |                               | 29662 |   347K|    31   (0)| 00:00:01 |  Q1,03 | PCWP |            |
                    |  20 |             BUFFER SORT              |                               |       |       |            |          |  Q1,03 | PCWC |            |
                    |  21 |              PX RECEIVE              |                               |       |       |            |          |  Q1,03 | PCWP |            |
                    |  22 |               PX SEND BROADCAST      | :TQ10000                      |       |       |            |          |        | S->P | BROADCAST  |
                    |  23 |                FAST DUAL             |                               |     1 |       |     2   (0)| 00:00:01 |        |      |            |
                    |  24 |             PX BLOCK ITERATOR        |                               | 29662 |   347K|    29   (0)| 00:00:01 |  Q1,03 | PCWC |            |
                    |  25 |              INDEX FAST FULL SCAN    | CMR_UN01                      | 29662 |   347K|    29   (0)| 00:00:01 |  Q1,03 | PCWP |            |
                    |* 26 |           SORT JOIN                  |                               |     1 |    11 |     4  (25)| 00:00:01 |  Q1,03 | PCWP |            |
                    |  27 |            BUFFER SORT               |                               |       |       |            |          |  Q1,03 | PCWC |            |
                    |  28 |             PX RECEIVE               |                               |     1 |    11 |     3   (0)| 00:00:01 |  Q1,03 | PCWP |            |
                    |  29 |              PX SEND BROADCAST       | :TQ10001                      |     1 |    11 |     3   (0)| 00:00:01 |        | S->P | BROADCAST  |
                    |* 30 |               TABLE ACCESS FULL      | REGULATORY_APPLICATION        |     1 |    11 |     3   (0)| 00:00:01 |        |      |            |
                    ---------------------------------------------------------------------------------------------------------------------------------------------------
                    
                    Predicate Information (identified by operation id):
                    ---------------------------------------------------
                    
                       5 - access("IMC"."CMP_ID"="ITEM_1")
                      10 - filter("FRM"."IML_ID" IS NOT NULL)
                      11 - access("FRM"."FRM_ID"=2060055)
                      13 - access("IMC"."IML_ID"="FRM"."IML_ID")
                      26 - access("CMR"."RAP_ID"="RAP"."RAP_ID")
                           filter("CMR"."RAP_ID"="RAP"."RAP_ID")
                      30 - filter("RAP"."PROCEDURE_NAME"='CHALLENGE_USA_HYDROCARBON')
                    
                    48 rows selected.
                    • 22. Re: Parallel Query
                      Richard Harrison .
                      Hi again,
                      There must be a logon trigger enabling this.

                      What do you see from this query

                      select * from dba_triggers where TRIGGERING_EVENT like '%LOGON%'


                      Cheers,
                      Harry
                      • 23. Re: Parallel Query
                        940856
                        Hello Mate,

                        There in no log-on trigger for the same.I did some goggling, but yet to find anything , which confirm this auto enabled stuff. but, definable, a big thanks to all of you.


                        SQL> select * from dba_triggers where TRIGGERING_EVENT like '%LOGON%';

                        no rows selected

                        Regards
                        • 24. Re: Parallel Query
                          VijayaraghavanKrishnan
                          Hi,

                          Oracle uses the DoP to determine to run the query in parallel. The DoP is set at table and index or hint at the SQL query. Use the below SQL to disable DoP on all the tables and indexes in the schema which ever you want.
                          alter table <tablename> noparallel;
                          Then enable the parallel query at the session level get the explain plan for your query.
                          alter session enable parallel query;
                          Thanks,
                          Vijay

                          Edited by: Vijayaraghavan Krishnan on Dec 7, 2012 11:23 AM
                          • 25. Re: Parallel Query
                            rahulras
                            Hi,

                            I think you missed my previous post. Which says,

                            What is the value for database level parameter PARALLEL_DEGREE_POLICY ?
                            If that is AUTO, Oracle decides if it wants to use parallelism (and it has full permission to use parallel query if it think so).

                            Set that parameter to MANUAL, if you don't want Oracle to make this decision.
                            • 26. Re: Parallel Query
                              940856
                              Hello Mate,

                              I did saw your post, but somehow , missed to reply back. It's set to manual. Still wondering , there must be some parameters , that will causing this undesired result.


                              ++++++
                              SQL> show parameter PARALLEL_DEGREE_POLICY

                              NAME TYPE VALUE
                              ------------------------------------ --------------------------------- ---------------
                              parallel_degree_policy string MANUAL
                              +++++
                              • 27. Re: Parallel Query
                                940856
                                Great Job !! , you are right with your findings. I altered their DOP and discovered , they are not using parallelism. Assuming, this is default behavior in 11g , so does, this mean , I need to make every table and index no parallel , if we do not wish to us parallelism by default and if we need , we can use hint or parallel setting , right ?
                                SQL> explain plan for
                                    SELECT SUM(IMC.TYPICAL_PERCENT)   TYPICAL_PERCENT
                                  2    3            FROM rds.ITEM_MASTER_COMPONENT   IMC,
                                  4                 rds.master_formula          frm
                                  5      WHERE FRM.FRM_ID = 2060055 AND
                                  6                   IMC.IML_ID = FRM.IML_ID AND
                                  7                 EXISTS (SELECT 'X' FROM DUAL WHERE
                                  8                         IMC.CMP_ID in (select cmp_id
                                  9                                from rds.component_regulation cmr, rds.regulatory_application rap
                                 10                             where cmr.rap_id = rap.rap_id
                                 11                             and rap.procedure_name = 'CHALLENGE_USA_HYDROCARBON')) AND
                                 12              frm.iml_id IS NOT NULL
                                 13  /
                                
                                Explained.
                                
                                SQL> select * from table (dbms_xplan.display);
                                
                                PLAN_TABLE_OUTPUT
                                --------------------------------------------------------------------------------------------------------------------------------------------------------
                                -------------------------------------------
                                Plan hash value: 890648619
                                
                                ----------------------------------------------------------------------------------------------------------------
                                | Id  | Operation                      | Name                          | Rows  | Bytes | Cost (%CPU)| Time     |
                                ----------------------------------------------------------------------------------------------------------------
                                |   0 | SELECT STATEMENT               |                               |     1 |    37 |    43   (3)| 00:00:01 |
                                |   1 |  SORT AGGREGATE                |                               |     1 |    37 |            |          |
                                |*  2 |   HASH JOIN SEMI               |                               |     1 |    37 |    43   (3)| 00:00:01 |
                                |   3 |    NESTED LOOPS                |                               |    21 |   504 |     8   (0)| 00:00:01 |
                                |*  4 |     TABLE ACCESS BY INDEX ROWID| MASTER_FORMULA                |     1 |     8 |     3   (0)| 00:00:01 |
                                |*  5 |      INDEX UNIQUE SCAN         | FRM_PK00                      |     1 |       |     2   (0)| 00:00:01 |
                                |   6 |     TABLE ACCESS BY INDEX ROWID| ITEM_MASTER_COMPONENT         |    21 |   336 |     5   (0)| 00:00:01 |
                                |*  7 |      INDEX RANGE SCAN          | ITEM_MASTER_COMPONENT_NDX_N01 |    21 |       |     2   (0)| 00:00:01 |
                                |   8 |    VIEW                        | VW_SQ_1                       |   115 |  1495 |    35   (3)| 00:00:01 |
                                |*  9 |     HASH JOIN                  |                               |   115 |  2645 |    35   (3)| 00:00:01 |
                                |  10 |      NESTED LOOPS              |                               |     1 |    11 |     5   (0)| 00:00:01 |
                                |  11 |       FAST DUAL                |                               |     1 |       |     2   (0)| 00:00:01 |
                                |* 12 |       TABLE ACCESS FULL        | REGULATORY_APPLICATION        |     1 |    11 |     3   (0)| 00:00:01 |
                                |  13 |      INDEX FAST FULL SCAN      | CMR_UN01                      | 29662 |   347K|    29   (0)| 00:00:01 |
                                ----------------------------------------------------------------------------------------------------------------
                                
                                Predicate Information (identified by operation id):
                                ---------------------------------------------------
                                
                                   2 - access("IMC"."CMP_ID"="ITEM_1")
                                   4 - filter("FRM"."IML_ID" IS NOT NULL)
                                   5 - access("FRM"."FRM_ID"=2060055)
                                   7 - access("IMC"."IML_ID"="FRM"."IML_ID")
                                   9 - access("CMR"."RAP_ID"="RAP"."RAP_ID")
                                  12 - filter("RAP"."PROCEDURE_NAME"='CHALLENGE_USA_HYDROCARBON')
                                • 28. Re: Parallel Query
                                  VijayaraghavanKrishnan
                                  Hi,

                                  Oracel 11g has auto DoP, I think some one might turned it on. Seeing in of the table you had the Defualt Degree I assume this is the case with your database.

                                  If you need to use the parallelism you can very well use the hint on the query or you alter for the session, change the degree for the respective table or index to use it.

                                  Thanks,
                                  Vijay
                                  • 29. Re: Parallel Query
                                    940856
                                    Thanks again , but , when you said , I had one of the index set as 'default' , according to you that actually triggered , parallelism , right ? but, in the same thread , I did change the degree to 1 and yet it preferred parallelism. what's you though on this ?