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

Thread: Query running does not take 16 parallel sessions

Threaded View

  1. 11-08-2006, 07:31 AM #6
    waitecj's Avatar
    waitecj
    waitecj is offline Advisor
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    Now check the number of parallel processes being used at any one time (select sid, req_degree "requested_dop", degree "actual_dop" from v$px_session order by sid; ). You might find that you don't have the maximum set high enough for your demand.
    Last edited by waitecj; 11-08-2006 at 07:32 AM. Reason: Stoopid emoticon at the end of "sid"
    Assistance is Futile...
    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