Re: Monitoring parallelism

Hi Rick,

Check out V$PQ_SESSTAT, V$PQ_SLAVE, V$PQ_TQSTAT, and V$PQ_SYSSTAT for details regarding what/if/how parallel operations were executed.

And as previously mentioned, you must specify the parallel clause (either at the table definition or via a hint) for Oracle to start creating more shovels and passing then around appropriately.

Cheers

Richard

Rick Denoire wrote:
>
> Hello
>
> I switched on parallel query by setting the init parameter
> PARALLEL_AUTOMATIC_TUNING=true and restarting the DB. Additionally, I
> set the max. number of parallel servers to 40 and the number of
> threads per CPU to 6.
>
> I haven't noticed any significant change in performance. How can I
> somehow see that parallelism is active at all? I understand that
> parallel query does not always result in a performance increase, but I
> am not sure that there is any parallelism at all. (Using Oracle
> 8.1.7/Solaris 2.7 on a Sun E3500 with 4 CPUs). If any long running job
> starts, it sticks to one CPU so the overall CPU usage never goes over
> 25%. I assume that if parallelism of any kind would be in effect, at
> least for some short periods of time the job would show a CPU usage
> above 25%. Most of the time, when only one job runs, the other 3 CPUs
> are sitting there doing almost nothing.
>
> Any sugestions?
>
> Thanks
>
> Rick
Received on Mon Aug 19 2002 - 00:29:54 CDT