Archives of the TeradataForum
Message Posted: Wed, 02 Jul 2003 @ 15:31:20 GMT
| Subj: | | AMP and PE states |
| |
| From: | | Anomy Anom |
<-- Anonymously Posted: Wednesday, July 02, 2003 10:51 -->
What do the different AMP and PE states in PMON indicate?
When a session shows the AMP active and the PE dispatching, I recognize that the AMP is doing work on behalf of a particular SQL.
But when the AMP is idle and the PE is dispatching what is going on? I know that would be the time the parser is doing his thing, but
what else is done in that state. I ask because I see sessions staying in that state for a long (minutes+ period). Is this a symptom of a
saturated system in flow control?
| 
