Re: Create table performance in 11gR2
- From: Dominic Brooks <dombrooks@xxxxxxxxxxx>
- To: "baitha@xxxxxxxxxxxxxxxxx" <baitha@xxxxxxxxxxxxxxxxx>
- Date: Thu, 3 Apr 2014 21:57:05 +0100
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
Other related posts:
