Hello. I want to get the sql text of the queries that ran at the database during a interval time without enabling the logging mechanisms (access or query).
Is there any system table/view that keeps automatically that information?
funny question - you don't want to enable a loggiing but you want the logging info.
no - that the purpose of DBQL which you need to enable.
Hello, I was thinking that the info about current queries should be in some place in the Teradata database as part of the normal operation of the database where it could be possible to "see" them without having to enable logging mechanisms.
In Oracle, the analogy would be the v$active_session_history view that keeps a history for recent active sessions’ activity. It works inherently with the operation of the database.