I want to know that is there any possibility of getting the logs for the uncommitted transactions. I need this to track all the transactions which are performed though they are not committed. Please share with me if any of you know the answer.
asked
Are uncommitted transactions written to flashback redologs?
Transactions are written to the ONLINE REDO logs.
You can mine this data with an Oracle package, DBMS_LOGMNR.
BE VERY CAREFUL WITH THIS PACKAGE! Corruption of the database is only a package call away. If you have Toad and the DB Admin module, we offer a GUI screen to let you walk through the the steps of getting to your transactions.
CREATE OR REPLACE PACKAGE SYS.dbms_logmnr IS
-- OVERVIEW -- -- This package contains the procedures used by LogMiner ad-hoc query -- interface that allows for redo log stream analysis. -- There are three procedures and two functions available to the user: -- dbms_logmnr.add_logfile() : to register logfiles to be analyzed -- dbms_logmnr.remove_logfile() : to remove logfiles from being analyzed -- dbms_logmnr.start_logmnr() : to provide window of analysis and -- meta-data information -- dbms_logmnr.end_logmnr() : to end the analysis session -- dbms_logmnr.column_present() : whether a particular column value -- is presnet in a redo record -- dbms_logmnr.mine_value() : extract data value from a redo record --
Yes uncommited transactions that are lately rolled-back will be written to flashback archived logs.
