-
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
-
If you post your procedure someone might have an answer.
-
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
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
|