This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
A lot of information is not captured when colleagues run numerous SQL codes on server. Oracle, SQL Server, Azure and others...
Would there be a clever way of capturing and archiving all this queries run?
It may be wise to collect these for several reasons;
So found out a similar feature is now available in SQL Server 2016 --> https://docs.microsoft.com/en-us/sql/relational-databases/performance/monitoring-performance-by-usin...
In oracle people use the script to fetch the SQL's run… SQL_FULLTEXT can be parsed and be shown in lineage as well ı suppose...
AND UPPER(U.USERNAME) IN ('oracle user name here')
ORDER BY TO_DATE(S.LAST_LOAD_TIME, 'YYYY-MM-DD/HH24:MI:SS') desc;
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.