Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2004
    Location
    San Antonio, Texas
    Posts
    47

    Red face Unanswered: Using intra_partition_paralellism?

    Hi All,
    When using intra_partition for loades we get mixed results. Sometimes it takes 45 min and other times 5 hrs. The query plan changes all the time and without being ablt to provide hints we can't do anything.

    Is there a way around this? We've stopped using it for loads but plan to try it for large index builds in the near future. Any advise?

    Thanks,
    Alyx

  2. #2
    Join Date
    Jan 2004
    Location
    San Antonio, Texas
    Posts
    47

    Re: Using intra_partition_paralellism?

    OOPS! Forgot we are using V8.1.4 64-bit on HP/UX 11i


    Originally posted by DBAgirl
    Hi All,
    When using intra_partition for loades we get mixed results. Sometimes it takes 45 min and other times 5 hrs. The query plan changes all the time and without being ablt to provide hints we can't do anything.

    Is there a way around this? We've stopped using it for loads but plan to try it for large index builds in the near future. Any advise?

    Thanks,
    Alyx

  3. #3
    Join Date
    Nov 2002
    Location
    Delaware
    Posts
    186

    Re: Using intra_partition_paralellism?

    What are you parms set too :

    Degree of parallelism (DFT_DEGREE) =
    Maximum query degree of parallelism (MAX_QUERYDEGREE) =
    Enable intra-partition parallelism (INTRA_PARALLEL) =

    You need to make sure you have atleast 1 cpu for each MAX_QUERYDEGREE,


    One of the things we noticed on loads is, while writing it would wait when a bunch of procesess were doing loads at the same time, we now set it at

    DFT_DEGREE = 1
    MAX_QUERYDEGREE = 4
    INTRA_PARALLEL = YES,

    Our loads now go quicker and it will use more procesess to build indexes.
    David Quigley

  4. #4
    Join Date
    Jan 2004
    Posts
    2

    Re: Using intra_partition_paralellism?

    Originally posted by quigleyd
    What are you parms set too :

    Degree of parallelism (DFT_DEGREE) =
    Maximum query degree of parallelism (MAX_QUERYDEGREE) =
    Enable intra-partition parallelism (INTRA_PARALLEL) =

    You need to make sure you have atleast 1 cpu for each MAX_QUERYDEGREE,


    One of the things we noticed on loads is, while writing it would wait when a bunch of procesess were doing loads at the same time, we now set it at

    DFT_DEGREE = 1
    MAX_QUERYDEGREE = 4
    INTRA_PARALLEL = YES,

    Our loads now go quicker and it will use more procesess to build indexes.
    I am just testing.

  5. #5
    Join Date
    Jan 2004
    Posts
    2

    Re: Using intra_partition_paralellism?

    Originally posted by shakilc
    I am just testing.
    again testing

Posting Permissions

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