Require SQL History...
531775Mar 13 2009 — edited Mar 14 2009Hello,
At our one of the live site we have a huge database built with 10g and have an application built with asp.net
From couple of days we found unexpeced behaviour of database like some rows from tables are deleted, some are modified and some are inserted also.
After a long survay of our asp.net application we fond that application is not generating any queris or sql statement that harms our database.
And we have a dought if any person is making this kind of activities, but we are not sure.
For maintanance perpose we have to give passwords to number of persons at site.
So how can we trace this kind of issue?
Can we get some history of SQL statement that are executed between specific period of dates?
We tried User Trace file but they are very lenthy and time consuming to analize as it stores too much data that we dont want.
Is there any other way to fight with the situation?