How to find sql text and session information history during a week
RaluceFeb 9 2012 — edited Jun 21 2013Hi
I'm runing on Oracle 11g database without audit. My boss want to see a transaction or update or delete in one croitocal information in a one table.
Our audit to this table is not active and i cannot find it in AUDIT_TRAIL table.
the only thing i want to do is to check SQL text and link it in session information table to get the user updating the table but i don't have historic data, i have only yesterday's and today's data.
Does someone know where i will find an historic data of sqltext and session, because i want to see the data from 1st february till today.
A query is appreciated if you have.
Thank you and hope to have solution from you.