home bbs files messages ]

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