Home » Infrastructure » Linux » how to find sql query history (Oracle 10G orcl in OEL 5.5)
how to find sql query history [message #543635] Thu, 16 February 2012 01:30 Go to next message
macsri
Messages: 3
Registered: February 2012
Junior Member
hi 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.

please 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 your results
Re: how to find sql query history [message #543638 is a reply to message #543635] Thu, 16 February 2012 01:33 Go to previous message
Michel Cadot
Messages: 59414
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The only way to to mine your archived logs (if your database is in archive log mode).
See Database Utilities
Chapter 17 Using LogMiner to Analyze Redo Log Files

Forgot to mention, of course SELECT are not there but as you want UPDATE...

Regards
Michel

[Updated on: Thu, 16 February 2012 01:34]

Report message to a moderator

Previous Topic: cannot start dbca in putty session
Next Topic: Only instance is auto start while system reboot
Goto Forum:
  


Current Time: Wed Oct 22 08:21:00 CDT 2014

Total time taken to generate the page: 0.17489 seconds