How to Trace Oracle Database

oracle

I was working with sql server databases for years and I am used to tools like sql server profiler for tracing all queries on particular database.

My question is – how to do this same thing with oracle database. I am using sql oracle developer version 19.2 and I don't see any option there for tracing DB.

I've also checked this question and tried several tools there (the question is quite old) with no success. Do I really need oracle enterprise manager for doing such a basic thing? (that is suggestion from one of the answers).

My application is written in .NET – why is it so hard in oracle to track queries that this app is triggering?

Best Answer

alter session set sql_trace=true is enough to get only SQL query text for the current session.

Export/import to a local system is also OK to get only SQL query text.

Related Question