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
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: 68418
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...


[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: Mon Mar 27 11:10:42 CDT 2023