Database Tuning (MOSC)

MOSC Banner

PX deq credit: send blkd

edited Oct 30, 2009 10:58AM in Database Tuning (MOSC) 9 commentsAnswered
I am running a create unique index command on a table. The table has about 300mil rows and has a DOP set to 8. The index took about an hour and a half to build (also 8 ways). During the build I have noticed a jump in waits for PX deq credit: send blkd. I'd like to see if I can do something to reduce these waits and hopefully to reduce the time it takes to create the index. I found a few articles, but they all concentrate on issues with a nonparallelized select being feed by a parallelize insert.

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