DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: PARALLEL_AUTOMATIC_TUNING INIT.ORA PARAMETER!

  1. #1
    Join Date
    Feb 2001
    Posts
    286
    Hi all!

    Working on Oracle v8i with OS as Win2000/NT.

    Query:

    What is the significance of PARALLEL_AUTOMATIC_TUNING and if set to TRUE
    in the INIT.ORA parameter,what would be the pros and cons on the following type of databases:

    1.DEDICATED.
    2.MTS.
    3.OLTP.
    4.DSS.

    Thanks & Regards,

    Amit.
    Oracle DBA (OCP) v8i,v9i

  2. #2
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    If PARALLEL_AUTOMATIC_TUNING is set to TRUE Oracle will set a number of other parameters automatically to facilitate parallel execution:

    http://download-west.oracle.com/otnd...190/ch1147.htm

    Parallel execution is used to improve the performance of large queries and DML operations by allocating additional slave processes to complete the task. The extra processes put an added drain on resourses which can affect performance of other statements.

    As for the next bit of your connection:

    DEDICATED - N/A. This is to do with how the client connects to the server, not the type of processing the server does.

    MTS - N/A. This is to do with how the client connects to the server, not the type of processing the server does.

    OLTP - Typically OLTP systems service lots of small transactions where data is accessed by it's primary key. Such transactions benefit little from parallel execution. In addition, the extra resources required may actually reduce total throughput on the server. There may be some scope for parallel execution of batch processes on an OLTP system during quiet times.

    DSS - This is what parallel execution was designed for since queries against DSS usually require alot of data to be retrieved and agregated. In addition, most DSS do not suffer from such high numbers of transactions as OLTP systems so the resource drain associated with parallel execution does not affect other users to the same degree.

    Remember, switching this parameter to true will not automatically make operations execute in parallel. This will only occur if the relevent parameters are set at table level or you are using optimizer hints.

    Cheers
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: oracle-base.com
    My blog: oracle-base.com/blog

  3. #3
    Join Date
    Feb 2001
    Posts
    286

    Hi Timhall!Another Doubt!

    Hi Timhall!


    Does setting PARALLEL_AUTOMATIC_TUNING=TRUE automatically sets LARGE_POOL_SIZE to its default value when say LARGE_POOL_SIZE=0 is set or not set at all after database is created afresh!

    Regards,

    Amit.

    Oracle DBA (OCP) v8i,v9i

  4. #4
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    If left unset it will be computed automatically.
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

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