Home » RDBMS Server » Performance Tuning » Parrallel Query Problem
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.
Previous Topic: PB statistic CBO
Next Topic: Index not used in outer join query
Goto Forum:
  


Current Time: Sat Dec 03 17:52:38 CST 2016

Total time taken to generate the page: 0.07286 seconds