SQL Performance (MOSC)

MOSC Banner

Incomplete execution plan?

in SQL Performance (MOSC) 5 commentsAnswered ✓

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 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center