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

Thread: Disable running of functions in parallel.

  1. 09-03-2002, 09:40 AM #1
    PFC
    PFC is offline Junior Member
    Join Date
    Mar 2001
    Posts
    46

    Question

    Hi All,
    We just upgraded our server to a multiprocessor machine. A counting function we were using is being run in parallel and this is causing miscounts.

    I know I can alter the session and remove parallel DDL and DML operations. I'm just not confident that Oracle really pays attention to the alter session command.

    So I would prefer to somehow specify that the called function must not be run in parallel.

    Any ideas?
    ora_newbie@yahoo.com
    Reply With Quote Reply With Quote
  2. 09-03-2002, 12:55 PM #2
    gandolf989's Avatar
    gandolf989
    gandolf989 is offline Senior Advisor
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    If you post your procedure someone might have an answer.
    Reply With Quote Reply With Quote
  3. 09-03-2002, 12:58 PM #3
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Hmm, most people have the opposite problem; how to get my query to run in parallel.

    Check your parallel parameters in the init.ora. Also, make sure the DEGREE of your tables is 1.
    Jeff Hunter
    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