Re: System Stats - MAXTHR and SLAVETHR

Hi Jonathan,
I read a few of your articles after my post and thought the same reason. Will collect stats again and make sure parallel jobs run during that time. Btw, 10053 show this as '-1 bytes/sec', but sys.aux_stat$ as NULL, so there was some confusion there too. Thanks,
Deepak  

    On Friday, September 2, 2016 2:34 AM, Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk> wrote:  

 #yiv4105052265 P {margin-top:0;margin-bottom:0;} A simple explanation would be that you gathered system stats over a period (start/stop option) in which no parallel queries occurred.  Those figures allow the optimizer to calculate the maximum effective degree of parallelism by comparing the maximum throughput the QC can take compared to the average throughput a PX slave can produce.

  
Regards
Jonathan Lewis
http://jonathanlewis.wordpress.com
_at_jloracle
From: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] on behalf of Deepak Sharma [dmarc-noreply_at_freelists.org] Sent: 02 September 2016 02:46
To: Oracle-L Freelists
Subject: System Stats - MAXTHR and SLAVETHR

A 10053 trace showed these as '-1 bytes/sec'. What does that mean?    

--
http://www.freelists.org/webpage/oracle-l