setting degree of parallelism at table level when default degree technique is used
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: setting degree of parallelism at table level when default degree technique is used

Hybrid View

  1. #1
    Join Date
    Oct 2001
    Location
    Calcutta , India
    Posts
    78

    setting degree of parallelism at table level when default degree technique is used

    Hi,

    I have one doubt. I have set

    cpu_count=12
    Parallel_automatic_tunning = 'TRUE'
    Parallel_max_server = 24 ( I have 12 cpus )
    Parallel_min_percent = 4
    Parallel_adaptive_multi_user =TRUE
    Parallel_threads_per_cpu=2

    As a result, default degree of parallelism is

    cpu_count*Parallel_threads_per_cpu*(a reduction factor)

    Now I want to use this default degree automatically for all tables. Now my question is : What the value should we provide for parallel cluase of create table statement so that default degree will
    be calculated and that degree will be used in the sql where this table will be used ?

    As I know If I give just

    create table dept (deptno number ) --> it will have value for parallel clause as 1 (default value) as we
    can check from dba_tables

    What should be the value of parallel clause in this scenario where we want to use default degree which will be decided by oracle dynamically ?

    Regards,

    Deba

  2. #2
    Join Date
    Jul 2001
    Location
    Slovenia
    Posts
    422
    you should specify parallel as in
    create table dept (deptno number ) parallel;

    and the value will be 'DEFAULT' not '1'
    Tomaž
    "A common mistake that people make when trying to design something completely
    foolproof is to underestimate the ingenuity of complete fools" - Douglas Adams

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