Database Tuning (MOSC)

MOSC Banner

Wait events for parallel execution

edited Jun 5, 2012 11:04PM in Database Tuning (MOSC) 4 commentsAnswered
Hello all

I have a parallel insert that performs quite ok. However I can see that it experiences some amount of differenct PX events. In order to find out if I could tweak the physical properties of the target tables/indexes, I have looked for some documentation of the wait events, but I can not find very much on the PX events. Master Note for Parallel Wait Events 1097154.1 refers to further notes on some of the events, but not all.

Does a complete documentation of weait events exist, and if so where?

One of the events that I came across is "PX Deq: Table Q Get Keys" I can not find anything on this event, so how do I learn what it means?

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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center