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,985 of 44,300    |
|    geos to Michel Cadot    |
|    Re: oracle assigned parallel threads    |
|    12 Apr 17 18:03:06    |
   
   From: geos@SPAMPRECZ.autograf.pl   
      
   On 12.04.2017 07:30, Michel Cadot wrote:   
   > "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   
      
   thank you!   
      
   geos   
      
   --- 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