Limiting the number of parallel query processes per user
Posted on 2000-05-16
I have a DW environment, where I'm setting about 30 parallel query servers (PARALLEL_MAX_SERVER=30). My problem is that when I use the DEFAULT degree of parallelism, Oracle 8i (8.1.5, i think) tends to allocate about 20 query servers to a single SQL, i.e., the lucky guy who gets to send the first query. The following users get stuck with very few query processes, and their queries take forever to run. Is there a way of telling Oracle to allocate a maximum of X query processes per user, something like saying "each user can get at most 8 query processes on his queries" ?