SQL Performance (MOSC)

MOSC Banner

need to understand the execution plan of a query

edited Mar 13, 2014 11:55PM in SQL Performance (MOSC) 4 commentsAnswered ✓

Hello ,

Please refer to the below execution plan.Please advise why these extra fields are coming in execution plan(Pstart,Pstop,TQ,IN-OUT and PQDistrib)and what does this mean?

Execution Plan

Id Operation Name Rows Bytes Cost (%CPU)Time PstartPstop TQ IN-OUTPQ Distrib
0 UPDATE STATEMENT 81240 (100)
1    UPDATE F_ENGAGEMENT_PERSON
2      PX COORDINATOR
3        PX SEND QC (RANDOM):TQ10000 145 6815 81240 (2)00:18:58 Q1,00 P->S QC (RAND)
4          PX BLOCK ITERATOR 145 6815 81240 (2)00:18:58 1 229 Q1,00 PCWC
5            TABLE ACCESS FULLF_ENGAGEMENT_PERSON 145 6815 81240 (2)00:18:58 1 229 Q1,00 PCWP

Back to Plan 1(PHV: 1931325571)
Back to Top

Full SQL Text

SQL IdSQL Text
bgqp3bkxw05muUPDATE DWADMIN.F_ENGAGEMENT_PERSON SET CLIENT_KEY=:2, HARD_START_DATE_KEY=:3, HARD_END_DATE_KEY=:4, SOFT_END_DATE_KEY=:5, IND_PRACTICE_GROUP_KEY=:6, ENG_EXPERTISE_ATTRIBS=:7, TAXONOMY_TERM_GROUP_KEY=:8, FUNCTIONAL_KEYWORD_GROUP_KEY=:9, FUNC_PRACTICE_GROUP_KEY=:10, PRELIMINARY_CHARGE_CODE=:11, LAST_MODIFIED_DATE=NVL(TO_DATE(:12, 'YYYY-MM-DD HH24:MI:SS'), SYSDATE) WHERE PROJECT_KEY=:1

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