| Parrallel Query Problem [message #202661] |
Fri, 10 November 2006 15:10 |
rkl1
Messages: 97
Registered: June 2005
|
Member |
|
|
Dear All,
Here is the strange problem we are facing. The query needs to use 4 tables out of which 2 of them were created with parallel (degree default) option. Now the query also uses 2 indexes which were also created with parallel degree=8. Now the whole query runs under a single thread and does not use parallel query at all. If we force it with alter session or using hints then parallel query are used.
I always thought that if query uses at least one full scan of table or index range scan (which were built with parallel option), then that would be the degree of parallelization of the query (drop). What we could do so Oracle would automatically use the parallel option rather than force to the session either by hints or alter session.
Thanks.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
