Re: ONLINE INDEX CREATION

Thanks Stefan. I will try that.

Thanks
Ramsankar Cheruvattath (Ram)
4072096276

On Fri, Sep 14, 2018 at 6:28 AM Stefan Koehler <contact_at_soocs.de> wrote:

> 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