Forums before death by AOL, social media and spammers... "We can't have nice things"
| comp.databases.oracle.server | Oracle Sysadmins question their careers | 44,300 messages |
[ << oldest | < older | list | newer > | newest >> ]
| Message 42,984 of 44,300 |
| "Michel Cadot" |
| Re: oracle assigned parallel threads |
| 12 Apr 17 07:30:01 |
"geos" 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
--- SoupGate-Win32 v1.05
* Origin: you cannot sedate... all the things you hate (1:229/2)
|
[ << oldest | < older | list | newer > | newest >> ]
(c) 1994, bbs@darkrealms.ca
