How to know last one hour transation what you did on the teradata database

Database
Enthusiast

How to know last one hour transation what you did on the teradata database

Suppose we are insrting and deleting and update no of record in teradata in a day but i want only last one hour transation what we did?

what is the query for taht?

1 REPLY
Enthusiast

Re: How to know last one hour transation what you did on the teradata database

You need to check the DBQL Log tables, they track the SQLs that has been executed on the system and you can put a filter on the user for which you want to see the results.

SELECT *
FROM DBC.DBQLSQLTBL
WHERE COLLECTTIMESTAMP >= CURRENT_TIMESTAMP - INTERVAL '1' HOUR
AND USER_ID = '<<USER_ID>>'