Re: Create table performance in 11gR2

From: Dominic Brooks <dombrooks_at_hotmail.com>
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 11.2.0.4 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

Dominic

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Apr 03 2014 - 22:57:05 CEST

Original text of this message