User activity monitor

[devendrap]

Hi,

I would like to monitor my Login.
Like When last time I quired on Tera Box?
How much time did it take to excute query?
How many session are running on my name?
What SQL is querying on Box?
From which machine query came from?

Is teradata any log file? or some table where could i see all information.

Thank you,

 

[ypinzon]

I would suggest that you install a copy of PMON. It can tell you how many sessions you have running, user name , where they connected from. The length of all queries?

 

[TheMartian]

Hi Devendrap

You could try quering the following DBC tables to give you most of the info you require. DBC.LOGONOFF and DBC.ACCESSLOG. The latter assumes that you have access logging enabled for the user id you are logging on with

TheMartian