Home » RDBMS Server » Performance Tuning » Parrallel Query Problem
Parrallel Query Problem [message #202661] Fri, 10 November 2006 15:10
Messages: 97
Registered: June 2005
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.

Previous Topic: PB statistic CBO
Next Topic: Index not used in outer join query
Goto Forum:

Current Time: Sat Jan 21 00:50:14 CST 2017

Total time taken to generate the page: 0.06643 seconds