Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to get all executed SQL queries in ORACLE?

Tags:

sql

oracle

Is possible to find out all SQL queries and their return code, which was executed in Oracle database? Specially I want to get all sql queries which has negative sql code (error).

Thank you for answer.

like image 804
Lukáš Kroczek Avatar asked Jan 10 '12 12:01

Lukáš Kroczek


1 Answers

Everything which was executed? That would require enabling auditing, and fine-grained auditing to boot - and auditing every statement in a database can generate a lot of data.

like image 80
Adam Musch Avatar answered Oct 02 '22 04:10

Adam Musch