how to get the sqltext from queries that ran during an time interval without enabling logging?

Database
Fan

how to get the sqltext from queries that ran during an time interval without enabling logging?

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?

Regards,

2 REPLIES
Senior Supporter

Re: how to get the sqltext from queries that ran during an time interval without enabling logging?

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.

Fan

Re: how to get the sqltext from queries that ran during an time interval without enabling logging?

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.

Best regards,