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

Thread: Few Questions on PARALLEL Option

  1. #1
    Join Date
    Sep 2000
    Posts
    155

    Few questions on PARALLEL option.........
    Would be greatful for all your input on each of these questions below.


    Can I use PARALLEL option in the CREATE TABLE or ALTER SESSION for an OLTP application OR is this advised only for DSS or DSD applications?


    Is is mandatory to use PARALLEL option only if there are more than one CPUs?


    Is PARALLEL option same as PARALLEL QUERY (we specify some init.ora parameters to TRUE) option or different? If different, in what way?



    Thanks in advance!

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    PARALLEL OPTION referes to the Parallel Query option in Oracle.

    Typically in an OLTP database, there is more overhead associated with setting up the parallel query and tearing it down than you can gain by using parallel queries. If you have a long query, it may benefit from the parallel option.

    You can use Parallel Query on 1 CPU machines. You will get best results when your CPU is not the bottleneck on the database.
    Jeff Hunter

  3. #3
    Join Date
    Sep 2000
    Posts
    155
    marist89, thanks for replying.

    When you say PARALLEL option is same as PARALLEL QUERY option...... then, do we have to specify it in the CREATE TABLE statement or ONLY in init.ora file or at both places....

    Also, could we use PARALLEL option during IMPORT/EXPORT?
    If YES, how???

    I am assuming that specifying it in init.ora file is MANDATORY.
    Correct me if I am wrong.

    [Edited by rpardip on 01-05-2001 at 11:58 AM]

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    You should set some attributes of the table as well as some init.ora parameters. Specify the default degree of parallelism for the table (see [url]http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a85397/statem2a.htm#2056873[/url] )

    You can override the default degree of parallelism by using the /*+ PARALLEL */ hint in your DML.

    Some DDL statements may be parallelized (see [url]http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76965/c22paral.htm#5509[/url] )

    There is an init.ora paramter that you can initially set that takes care of 80% of the parallel tuning you need ( see [url]http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76961/ch1135.htm#67101[/url] )

    I am not sure about parallel import/export.


    [Edited by marist89 on 01-05-2001 at 12:25 PM]
    Jeff Hunter

  5. #5
    Join Date
    Sep 2000
    Posts
    155

    Thanks marist89 for sharing this info.

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