Re: oracle assigned parallel threads
From: Michel Cadot <micadot{at}altern{dot}org>
Date: Wed, 12 Apr 2017 07:30:01 +0200
Message-ID: <58edbb59$0$712$426a34cc_at_news.free.fr>
| thank you,
| geos
Date: Wed, 12 Apr 2017 07:30:01 +0200
Message-ID: <58edbb59$0$712$426a34cc_at_news.free.fr>
[Quoted] "geos" <geos_at_SPAMPRECZ.autograf.pl> a écrit dans le message de news: 58e918a9$0$5159$65785112_at_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
Received on Wed Apr 12 2017 - 07:30:01 CEST