DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

Thread: parallel nologging is not faster.

  1. #11
    Join Date
    Nov 2000
    Location
    Baltimore, MD USA
    Posts
    1,339
    Do you have PARALLEL_AUTOMATIC_TUNING set to true in init.ora?

    - Chris

  2. #12
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Change the init.ora file as given below:
    # Set up Parallel Query Parameters
    optimizer_percent_parallel = 50
    parallel_min_percent = 50
    parallel_min_servers = 8
    parallel_max_servers = 10

    Shutdown and Startup the instance.

    Also remember that the underlying table on which you create index must be already created with parallel degree.
    I have tested many times that NOLOGGING mode on table or index speeds up creation process.

    The rule of parallelism is:
    Parallel Query Processes = Min of number of CPUs or the number of disks on which the datafile spreads which ever is less.

    Even though you have 8 CPU, but the Index data file is NOT striped, then you don't see any improvement on parallel query.


  3. #13
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    The master speaks... http://asktom.oracle.com/pls/ask/f?p...0_P8_DISPLAYID,F4950_P8_CRITERIA:1231781710382,
    Jeff Hunter

  4. #14
    Join Date
    Apr 2001
    Posts
    219

    Cool

    Hmm, sounds similar to what I said.
    ______________________
    Applications come and go,
    but the data remains!

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