Archives of the TeradataForum

Message Posted: Mon, 18 Nov 2002 @ 21:01:48 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Tony,

DISKIO is the number of LOGICAL I/Os performed and not PHYSICAL I/Os. An I/O equates to a single read or write operation on the disk. But because this is logical the data may be written or read from cache without the actual physical disk operation taking place. Obviously, caching and synchronized scan can dramatically impact these figures. DBC.AMPUSAGE contains cumulative resource usage information since that last time the figures have been reset.

Regards,

Doug Drake

	<Prev	Next>		<<First	<Prev	Next>	Last>>