How to record SQL statements that did not execute successfully

fanswar78

That's it, I have this scenario:
There is an Oracle database. After the application runs for a period of time, which SQL statements are not successfully executed through the database, for example, the update statement sent to the database is not executed because of data errors.

fanswar78

note:
Can't change application

I tried to use the log file, but I couldn't find a way to worry about it. I read the Logminer manual, it seems that I can't achieve this function, that is: I only select the statement that was successfully executed, and the statement that was not successfully executed.

fanswar78

To add one more point, I want to implement such a function, that is to say, I am a database manager, and the database I manage is used by several applications. I now want to make a statistics to see which applications have been sent over a period of time. sql statements, which are executed successfully and which are not executed successfully

whbilly

alert.log
In the $ ORACLE_BASE / admin / instancename / bdump directory

whbilly

Or, change your own program, add exception handling, and record in the log table

fanswar78

to:
alert.log
In the $ ORACLE_BASE / admin / instancename / bdump directory
It seems that there is no sql statement saved in alert.log

fanswar78

to:
Or, change your own program, add exception handling, and record in the log table

=====================

Can not change the program, the program is already done, a very large program, which contains thousands of SQL statements.

whbilly

There is another way to audit the table.
The parameters of the init file must:
audit_trail = DB
such as:

Log in as user user. Plan to audit the insert operation of table user.test.
  The operation is as follows:
  audit insert on user.test;
  insert into test values ​​(....);
  select * from sys.aud $;

onlysnake

Can't the v$sql statement find out the executed sql statement and status?