|
Archives of the TeradataForumMessage Posted: Mon, 07 Jul 2003 @ 20:53:06 GMT
Many thanks for the reply..!! It was just that the database was running slow and moreover the 100% CPU utilisation alarmed me a bit. So 100% utilisation is normal when database is under load. I checked the sessions via PMON and it showed me a lot of user sessions which were in dispatching and response stage. I wonder whether that is what is slowing down the database. Can someone tell me what is the state of the query when the PE shows 'dispatching' or 'response'..? What I want to know is that what do these states signify actually..?? Rgds, Rohit
| ||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
Copyright 2016 - All Rights Reserved | ||||||||||||||||||||||||||||||||||||||||||||||||
Last Modified: 15 Jun 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||