RE: System Stats - MAXTHR and SLAVETHR

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 2 Sep 2016 07:29:31 +0000
Message-ID: <CE70217733273F49A8A162EE074F64D9015033AA7F_at_exmbx05.thus.corp>

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

Received on Fri Sep 02 2016 - 09:29:31 CEST

This message: [ Message body ]
Next message: Jonathan Lewis: "RE: Enforcing SQL execution plan"
Previous message: Michael D O'Shea/Woodward Informatics Ltd: "Re: I'm stuck replace(column, '''') and replace(column,chr(39)) not working"
In reply to: Deepak Sharma: "System Stats - MAXTHR and SLAVETHR"
Next in thread: Luis Santos: "Re: System Stats - MAXTHR and SLAVETHR"
Reply: Luis Santos: "Re: System Stats - MAXTHR and SLAVETHR"
Reply: Deepak Sharma: "Re: System Stats - MAXTHR and SLAVETHR"
Reply: Mladen Gogala: "Re: Creating unique index on huge table."

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message