question

OraLearner avatar image
OraLearner asked

Are uncommitted transactions written to flashback redologs?

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.

oraclelogs
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

HillbillyToad avatar image
HillbillyToad answered

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 --

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

OraLearner avatar image
OraLearner answered

Yes uncommited transactions that are lately rolled-back will be written to flashback archived logs.

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.