How to see update and insert statements that were executed - Oracle 9i?
Posted on 2012-03-13
I am a newbie and I have an oracle database with a couple of hundred tables that an application connects to. I want to know if there is an easy way that I can see what tables are updated (including inserts) when I perform certain actions through the application?
Information I would like to recover:
(i) What row(s) was inserted or updated in in each table -e.g the 'update' or 'insert' statement actually submitted.
(ii) If possible, the 'select' statements also that would of been executed.
Please I would like the easiest way to achieve the above and one with details that I could follow.