Hello,

I am having really bad performance problems in my database. At times the tellers are waiting up to a minute for a page to turn. In looking at waits I observed the following output:
Total Total Time Avg
Waits Timeouts Waited % of Wait
Event Name (in 1000s) (in 1000s) (in Hours) Concern (Secs)
-------------------------- ----------- ----------- ----------- ------- -------
parallel query dequeue wait 1,756.12 1,756.09 980.53 87.97 2.01

This was the top wait event by far. What does this event mean? My largest table in the database has a degree of 4 for paraellel query. Thank you!!