Archives of the TeradataForum

Message Posted: Thu, 27 Jul 2000 @ 20:49:15 GMT

Hi, We need to know if the CPU or I/O usage is accumulative per session number for the Teradata Manager's utilities, so, if you run a
query that consume 300 secs.CPU and later, in the same session, you run another that consume 200 secs.CPU, the CPU usage in Teradata
Manager's Utilities for this session is 500 secs.CPU... I'm right?

The problem is, when I define an alert in the Alert Policity which abort sessions when reach the threshold, and the value of CPU or IO
usage is not real, is the total session value, and not the amount of the current query. This is an error because is not the real consume of
the query. There is a way to reset this value for each query in the same session, like the "$D$T" in the accountname?