Database DataWarehousing (MOSC)

MOSC Banner

PX Deq Credit: Send blkd top most wait event in AWR

edited Feb 28, 2012 3:26AM in Database DataWarehousing (MOSC) 3 comments

Hello Gurus,

I have collected AWR report for peak hours snapshots (3 hrs), and following is the TOP 5 Timed Events:

Event

Waits

Time(s)

Avg Wait(ms)

% Total Call Time

Wait Class

PX Deq Credit: Send blkd

20,123

13,991

695

  1. 39.8

other

CPU Time

11,778

  1. 33.5

df file sequential read

728,444

3,607

5

  1. 10.3

User I/O

db file scattered read

797,421

2,447

3

7

User I/O

log file parallel write

19,960

295

15

  1. 0.8

System I/O

The top most wait event is PX Deq Credit: Send blkd. I gone through some of the oracle documents which says that this type of wait event is normal even though it is the top most  event in AWR. But other docs specifies that not in all situations this is normal. I just know that this wait event is related to Parallel Processing. 

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