Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 13 Mar 2012 @ 09:21:59 GMT


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


Subj:   Re: To find the CPU Usage of the system
 
From:   sobhan.k.pratim

     SELECT UserName,AccountName , SUM(LogonTime), SUM(QueryBand)
       FROM DBC.SessionInfoV
       where DefaultDataBase like 'FDWQ%DE%'
          OR DefaultDataBase like 'FDWQ%CPS%'
          OR DefaultDataBase like 'FDWQ%SBSL%'
          OR DefaultDataBase like 'FDWQ%RACE%'
       GROUP BY 1,2


     
  <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: 15 Jun 2023