Re: oracle assigned parallel threads

On 12.04.2017 07:30, Michel Cadot wrote:
> "geos" <geos_at_SPAMPRECZ.autograf.pl> a écrit dans le message de news: 58e918a9$0$5159$65785112@news.neostrada.pl...
> | suppose I use a hint /*+ PARALLEL(8) */ in a query. how can it be
> | verified that oracle actually assigned this number of threads? or maybe
> | less/more? is there any dynamic/system view that contains such
> | information? if so, what is the view name?
> |
> | thank you,
> | geos
>
> V$PX_SESSION
> V$PX_SESSTAT
>
> Regards
> Michel

thank you!

geos Received on Wed Apr 12 2017 - 18:03:06 CEST