0

Example: I inserted data to Oracle Query executed successfully but no data is updated in db. So I want to see the same query in Oracle SQL Developer whether its executed or not, how long it took, what data came with insert query.

TTT
  • 1,848
  • 2
  • 30
  • 60
Alex
  • 19
  • 6
  • @FerasAlSous The issue you mention isn't even related. The OP is interested in whether something similar to `SQL Server Profiler` exists for Oracle SQL Developer. – Peter Abolins Sep 13 '17 at 06:20
  • you can log it manually combining stopwatch and exceptions – D Ie Sep 13 '17 at 06:22
  • https://stackoverflow.com/questions/148648/oracle-is-there-a-tool-to-trace-queries-like-profiler-for-sql-server That might have some useful information for you. – Peter Abolins Sep 13 '17 at 06:30

1 Answers1

0

Consider enabling SQL trace.

The quickest way to capture the SQL being processed by a session is to switch on SQL trace or set the 10046 event for a representative period of time. The resulting trace files can be read in their raw state or translated using the tkprof utility.

Some more info with examples here

Littlefoot
  • 131,892
  • 15
  • 35
  • 57