I have tried to search is there any system/log table which stores execution details of a DML query.
Asked
Active
Viewed 366 times
0
-
you can install ssms tools. for saving log (i tried in sql server 2008) – Hiren gardhariya Aug 09 '13 at 06:27
-
1@Hirengardhariya: The OP is talking about Oracle, not about SQL Server – Daniel Hilgarth Aug 09 '13 at 06:34
-
@DanielHilgarth OK. but in question tag you can see sql also. – Hiren gardhariya Aug 09 '13 at 06:40
-
Does "DML query" mean a `SELECT` statement? Or an `INSERT`/ `UPDATE`/ `DELETE`? – Justin Cave Aug 09 '13 at 06:43
-
@JustinCave It may be any query Insert/Update/Delete. – Suryanarayan Padhi Aug 09 '13 at 06:49
-
I'm still not quite understanding. Does "any query" mean to include `SELECT` statements? – Justin Cave Aug 09 '13 at 06:57
-
1. If audit is enabled you could query audit trail `SYS.AUD$` directly or via `dba_audit_*` views; 2. if audit is not enabled, but your database is in archive log mode, you can analyze archive log files using `DBMS_LOGMNR` package. – Nick Krasnov Aug 09 '13 at 07:01
-
1@Hirengardhariya: `SQL` is a query *language* it is ***not*** a DBMS product. The database system you are referring to is called "Microsoft SQL Server" not "*SQL*" – Aug 09 '13 at 07:23