Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 17 Aug 2005 @ 14:18:33 GMT


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


Subj:   Current Query that is being executed by any user.
 
From:   Khan, Rashid

Hi All,

I am looking for information where I need find the current query that is being getting executed by any particular user.

I know I can get this information from Performance Monitor screen in TD Manager, what I am looking for is getting this information from some Data Dictionary tables.

How does "Monitor SQL" works ? What is the procedure to execute it ? What is that I need to take care of ?

Just for information DBC.Accesslog is not what I am looking for as my environment doesn't populate all occurance of query by user to DBC.Accesslog


Regards

Rashid



     
  <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: 27 Dec 2016