Incomplete execution plan?
Hi Community Members!
I was trying to get the execution plan for a query that is performing poorly versus the QA testing counterpart, but ran into a space issue.
I wanted to know if the results are beneficial or if I need to get more temp space and run it to completion to get better insight?
ERROR at line 1: ORA-12801: error signaled in parallel query server P00F, instance xxxxxxxxxx:xxxxxx (1) ORA-01652: unable to extend temp segment by 128 in tablespace TEMP SQL> SELECT * FROM table(DBMS_XPLAN.DISPLAY_CURSOR(FORMAT=>'ALL +OUTLINE')); PLAN_TABLE_OUTPUT -------------------------------------------------------------------------------------------------------------------------------------------------------------------------- SQL_ID 0ph8rp1ab6jrs, child number 0 ------------------------------------- select /*+ gather_plan_statistics */ PERIOD, effective_date, LEDGER, COST_CEN_ID, ACCOUNT_ID from sum_view where period in (select period_name from dwh_period where end_date >= trunc(sysdate,'YEAR')) Plan hash value: 4085325935 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------- | Id | Operation | Name