Re: Concerned regarding parallel query and 10g (10.1.0.4)

Hello !
Three first ideas about Your problem :
1. set parallel_automatic_tuning to true

• it automatically sets most of initialization parameters regarding pq to appropriate values 2. there is another important parameter - LARGE_POOL_SIZE - parallel query servers use large pool for its buffers - so check utilization of large pool in v$sgastat and if needed increase its size 3. And another parameter :-) - parallel_threads_per_cpu - its value sets desirable parallelism degree per one CPU regards Witek Swierzy wswier_at_sgh.waw.pl