Re: ONLINE INDEX CREATION

Hello Ram,
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 ago: https://blogs.sap.com/2014/02/10/oracle-troubleshooting-parallel-executions-px-what-the-heck-why-is-the-sql-not-executed-in-parallel/

Best Regards
Stefan Koehler

Independent Oracle performance consultant and researcher Website: http://www.soocs.de
Twitter: _at_OracleSK

> Ramsankar Cheruvattath <ram.cheruvattath_at_gmail.com> hat am 13. September 2018 um 19:31 geschrieben:
>
> I am running it again in a lower environment, this time without ONLINE. These are servers with 288 cores and 4TB SGA. Parallel servers setting all look good. Still not running in PARALLEL. I will be doing more testing without COMPRESS etc.
>  
> Still interested to hear from others if they have an suggestion/queries I can use to troubleshoot this. I am also gathering a 10046 trace.

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