DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 14

Thread: Parallel query

  1. 09-10-2005, 07:04 PM #1
    bang_dba
    bang_dba is offline Senior Member
    Join Date
    Sep 2002
    Posts
    376

    Parallel query

    Hi,
    Is there any setting to be done to enable parallel query, apart from using the hint ??
    I am using Oracle 9.2
    ------------------------------------------------------------------------
    The most enjoyable things in the world are either Immoral or too Expensive or otherwise Inaccessible anyway
    Reply With Quote Reply With Quote
  2. 09-10-2005, 07:54 PM #2
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    you dont need hints if your tables/indexes are configured with parallel degrees
    Reply With Quote Reply With Quote
  3. 09-10-2005, 08:12 PM #3
    bang_dba
    bang_dba is offline Senior Member
    Join Date
    Sep 2002
    Posts
    376
    Ok.
    But is there any hardware requirement like dual cpu's, multiple disks etc. Or are there any init.ora parameters to be configured ?
    ------------------------------------------------------------------------
    The most enjoyable things in the world are either Immoral or too Expensive or otherwise Inaccessible anyway
    Reply With Quote Reply With Quote
  4. 09-11-2005, 04:12 AM #4
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    set parallel_max_server > 0

    no hardware related
    Reply With Quote Reply With Quote
  5. 09-11-2005, 05:16 AM #5
    tabreaz
    tabreaz is offline Senior Member
    Join Date
    Sep 2005
    Posts
    278
    I think for parallel processing we need to have more than one cpu; is it?
    Reply With Quote Reply With Quote
  6. 09-11-2005, 05:34 AM #6
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Obviously you dont need more than one CPU to run parallel query
    Reply With Quote Reply With Quote
  7. 09-11-2005, 05:40 AM #7
    tabreaz
    tabreaz is offline Senior Member
    Join Date
    Sep 2005
    Posts
    278
    Then how can it parallize, will it internally multiple slaves?, if it use multiple slaves then it can only do IO parallely but it will not run the applications in parallel.right?
    Reply With Quote Reply With Quote
  8. 09-11-2005, 05:58 AM #8
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    What makes you think modern CPUs can run a process only.... :-?
    Reply With Quote Reply With Quote
  9. 09-11-2005, 06:10 AM #9
    tabreaz
    tabreaz is offline Senior Member
    Join Date
    Sep 2005
    Posts
    278
    I doesnot mean to say what u interpreated as,

    i mean at one time the CPU can run only one job;
    Reply With Quote Reply With Quote
  10. 09-11-2005, 06:28 AM #10
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Quote Originally Posted by tabreaz
    I doesnot mean to say what u interpreated as,

    i mean at one time the CPU can run only one job;
    Is that true...?

    Right now I am burning a DVD, listening to mp3, running 2 ftp sessions, browsing with Firefox with a single CPU PC
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width