I'm working a project in which I'm debugging through a batch process that's doing a lot of DML statements. However, it doesn't do a commit immediately. In Oracle, is there a way I can see pending changes from another session when the transaction isn't committed? Thanks!
If I make any changes(Insert/Delete/Update) in a site then the corresponding changes will store in tables of that particular DB. How to know on which table which operation(DDl/DMl)has done. I would like to store DML activities on Database level in a table,not on particular table. Please help.