Re: Create table performance in 11gR2

From: Dominic Brooks <>
Date: Thu, 3 Apr 2014 21:57:05 +0100
Message-ID: <DUB406-EAS215D106519E13A3D6C1FAB5A16C0_at_phx.gbl>

You've given an explain statement of a select not of the CTAS. They may or may not be the same - quite possibly not given your CTAS is asking for parallel 4.

You really need to confirm the actual execution plan in your via DBMS_XPLAN.DISPLAY_CURSOR and ideally supplement this with information from real-time SQL monitoring via SELECT DBMS_SQLTUNE.REPORT_MONITOR(sql_id) FROM DUAL or from sample waits from ASH (both of which have extra licensing requirements). Or even better do an extended SQL trace.

Hope this helps


Received on Thu Apr 03 2014 - 22:57:05 CEST

Original text of this message