Thanks Stefan. I will try that.
Ramsankar Cheruvattath (Ram)
On Fri, Sep 14, 2018 at 6:28 AM Stefan Koehler <contact@xxxxxxxx> wrote:
you can trace the PX behavior by setting "_px_trace" (e.g. SQL> alter
session set "_px_trace"=high,all;).
I have also written a blog post about troubleshooting PX several years
Independent Oracle performance consultant and researcher
Ramsankar Cheruvattath <ram.cheruvattath@xxxxxxxxx> hat am 13.September 2018 um 19:31 geschrieben:
These are servers with 288 cores and 4TB SGA. Parallel servers setting all
I am running it again in a lower environment, this time without ONLINE.
look good. Still not running in PARALLEL. I will be doing more testing
without COMPRESS etc.
I can use to troubleshoot this. I am also gathering a 10046 trace.
Still interested to hear from others if they have an suggestion/queries