how to find sql query history
917887Feb 16 2012 — edited Nov 19 2012hi friends ,
am using orcl 10g in my oracle enterprise server, we use this interface to connect the database Sql Developer Ver 1.1.3,
how to find the sql history, now i need to check 3 to 4 months back what are the update statement that has been queried and how to check the logs,
though i have checked lots of views such as v$sqlarea ... etc i couldnot find any queries, and why i couldnot open redo logs.
plz tell me is there any option to restrict update command in the future,
also help me how to find the history , or what i should do further ,
Waiting for ur results