Archives of the TeradataForum

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

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

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>>