oracle - Find out the history of SQL queries -

oracle - Find out the history of SQL queries -

any 1 have executed update sql query on server. this, many problems coming now. want list of update queries executed on lastly 2 months trace exact sql query beingness problem.

can please help me on this?

thanks!!

select v.sql_text, v.parsing_schema_name, v.first_load_time, v.disk_reads, v.rows_processed, v.elapsed_time, v.service v$sql v to_date(v.first_load_time,'yyyy-mm-dd hh24:mi:ss')>add_months(trunc(sysdate,'mm'),-2)

where clause optional. can sort results according first_load_time , find records 2 months ago.

oracle sql-update database-administration