Database DataWarehousing (MOSC)

MOSC Banner

Developers are going nuts using /*+parallel/* hints setting values at 25 and more on an 8 CPU Itaniu

edited Apr 18, 2012 3:42AM in Database DataWarehousing (MOSC) 14 commentsAnswered
Is there a rule of thumb on the number of processes I can tell them not to exceed?  Such as no more than 8 on an 8 CPU box?  I am seeing waits like this  Waiting for event "PX Deq Credit: send blkd" in wait class "Other" accounted for 94% of the database time as a result.

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