CODEWITHSUNDEEP
sqldatabaseoracle-databaseoracle-sqldeveloper
user3163495
user3163495

Reputation: 3518

View SQL statement history sent from applications?

In Oracle SQL Developer, is there a way to see the SQL statement history sent from applications?

For example, I'm using the Oracle.DataAccess.dll library in my ASP.Net application to talk to my database. Is there a way to see the history of SQL statements (in raw text) sent to the database from it, from within Oracle SQL Developer?

Upvotes: 1

Views: 330

Answers (1)

thatjeffsmith
thatjeffsmith

Reputation: 22412

Not really, no.

Unless - you have enabled tracing for your ASP.NET's application session in the database.

Then, if you have access to the trace file - which will be on the server, and you'll need to get down to where SQL Developer can read it, then we can show you what's in the Trace file.

enter image description here

There are OTHER places to find SQL's that have been execute, but you won't find an audit trail for every executed for each application.

So my advice, using TRACING.

Upvotes: 1

Related Questions