Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

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


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


Subj:   Re: DISKIO on DBC.AMPUSAGE
 
From:   Doug Drake

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>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020