how to find session generating lots of redo in Oracle database

To find sessions generating lots of redo in Oracle database , you can use either of the following methods. Both methods examine the amount of undo generated. When a transaction generates undo, it will automatically generate redo as well. How to find session generating lots of redo in Oracle database 1) Query V$SESS_IO. This view …

how to find session generating lots of redo in Oracle database Read More »