Home > database >  For help, why I don't even the most basic query are parallel mode
For help, why I don't even the most basic query are parallel mode

Time:10-04

From v $session queries, see the current PLSQL reply actually are parallel mode? How to solve?

Waiting for there are two types of events, px deq respectively: execution MSG and execute the reply

Mobile Posting no picture please forgive me! Thank you for

CodePudding user response:

See

The select u.d egree from user_tables u

CodePudding user response:

not met, to the top

CodePudding user response:

Generally said, execute the reply is idle wait event, all the basic query in parallel mode?
Table didn't deliberately driving parallel?
There is no other operating contention caused by parallel
Whether it is distributed deployment
These can all be reasons
  • Related